Can you provide a sample workbook and explain what's your expectation with your sample data?
Hi Brooke, can you surround the datediff calculation with an if then ? My initial thoughts are that the datediff is returning a number less than zero .
IF (calculation) <0 then 0
Unfortunately I can't share a workbook. What I'm trying to achieve is to show the average days waited for services. Here is a screenshot of what I'm getting:
It appears that when the average days waited is 0 then I get a blank. To reduce confusion I'd just like the 0 to show. I tried wrapping my calculation in the IF statement suggested above, and can't seem to figure out the syntax to get that to work.
Can you upload an example .twbx please ?