Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

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