Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!

Calculated Column

Avatar

Former Community Member
Hello, I have entered this into a column on a task report but it's not working: displayname=Age Since Entry Date textmode=true valueexpression=IF(status='CPL', WEEKDAYDIFF(actualStartDate, actualCompletionDate), (WEEKDAYDIFF(actualStartDate, $$NOW)) valueformat=HTML Would appreciate any help or advice. Thank you. Nadia Shakfeh IEHP
1 Reply

Avatar

Level 1
Please try this: valueexpression=IF(status='CPL', WEEKDAYDIFF({actualStartDate}, {actualCompletionDate}), WEEKDAYDIFF({actualStartDate}, $$TODAY)) Siva Addepally