Expand my Community achievements bar.

Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Suggestion for text mode to Sum Vacation Days in Report

Avatar

Level 10

Hi,

 

Created a user based report to collect all the vacation days including date and numbers. 

Used below taxt code to collect all days in timeoff. 

displayname=Vacation Days in 2022 (Working Days Only)
listdelimiter=<br>
listmethod=nested(reservedTimes).lists
textmode=true
type=iterate
valueexpression=IF({endDate}>$$TODAYey,"",IF({endDate}>$$TODAYby,SUM(ROUND(WEEKDAYDIFF({startDate},{endDate})),0),""))
valueformat=HTML

Appreciate your suggestion in this regard.

Commnty_Vacation.jpg

Best regards,

Kundan.

0 Replies