Expand my Community achievements bar.

The next phase for Workfront Community ideas is coming soon. Learn all about it in our blog!

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