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
Topics
Topics help categorize Community content and increase your ability to discover relevant content.
I would try this for the valueexpression
valueexpression=IF(status='CPL',WEEKDAYDIFF(actualStartDate,actualCompletionDate),WEEKDAYDIFF(actualStartDate,$$NOW)) You had 4 left parens, but only 3 right parens. I don't think you need the left paren before the 2nd WEEKDAYDIFF
Hi Nadia, The only thing missing are brackets around your fields. displayname=Age Since Entry Date textmode=true valueexpression=IF({status}="CPL", WEEKDAYDIFF({actualStartDate}, {actualCompletionDate}), WEEKDAYDIFF({actualStartDate}, $$NOW)) valueformat=HTML Justin Renteria SSFCU