Expand my Community achievements bar.

IF Calculation on 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
Topics

Topics help categorize Community content and increase your ability to discover relevant content.

4 Replies

Avatar

Community Advisor
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

Avatar

Former Community Member
Thank you. Unfortunately it still isn't producing any results. Nadia Shakfeh IEHP

Avatar

Level 6
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

Avatar

Former Community Member
It worked! Thank you so much, Justin :) Nadia Shakfeh IEHP