Attempting to create a formula that shows how long our requisition has been opened. I attempted with DDiff(requisition created date, todays date) but formula is unsuccessful.

Hi hlister , You are probably attempting to do it in the dashboard, and the error is likely to be "The DDIFF function must be wrapped" in an aggregation function. The DDIFF function is not an aggregation, so it calculates the time difference on each row of the underlying response of the generated query. As a result, to be valid, you must indicate an aggregation. So if you are to write something like "DDIFF(Requisition_Create , Now())" you can use MIN, MAX or AVG with the same result if your dim...

Days between x and today | Help and How-To

MoreDiscussions

Days between x and today | Help and How-To | Sisense Community