Expand my Community achievements bar.

The Community Advisors application is now OPEN for the second class of 2024. Apply to become a part of this exclusive program!

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