Get the count of number of days between two dates if they are greater than zero

[apoorvasd]

Hello everyone,

I have a requirement where I need to get the count of values in a field which are greater than Zero.

I have three fields namely, "Date Completed", "Target Completion Date" (both are Date fields) and "DateCompleted - TargetCompletionDate". Field, "DateCompleted - TargetCompletionDate" has values which is the difference of "Date Completed" and "Target Completion Date" (ie., No. of days between the two dates) as shown in the attached picture. Now, I need to get the count of these values which are greater than zero.

I am trying the following expression, count([DateCompleted - TargetCompletionDate])>0 but not getting the desired output. I get -1 as the result which should be 9 as per the attached example.

Any help on this?

Thank you.

[prat1507 · Accepted solution]

Hi

Please use count({<[DateCompleted - TargetCompletionDate]={'>0'}>}[DateCompleted - TargetCompletionDate])

Regards

Pratyush

[apoorvasd]

Hi Pratyush,

Thank you very much

It's working !