Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Datediff result is Zero

I have created a Query which should bring for “date2” which has a date the following difference date1-date2 in days. Unfortunately I have a lot of 0. The datediff as below: Days = 1*(if(Query[da...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks I am using the filter.

jthomson's avatar
jthomson
Icon for Solution Sage rankSolution Sage
6 years ago

Add an if statement to do so, either in the datediff calculation you're doing right now or in the end average you're trying to calculate, to convert your zeroes to nulls/blanks and/or filter them out?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks I am using the filter.