Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

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