Number Of Days With Working Duration >0

[N_avya1]

Hello, 

I have a Field Working Duration and Wanted to Create a master Item for working Days

Number of working Days with Working Duration>0 

Please Correct me if this expression is not correct .

Count({<Working_Duration={">0>"}>}distinct DAY_DATE)

[MatheusC · Accepted solution]

@N_avya1 

Try it this way:

one option is to create a flag

if(Count({<Working_Duration = {">0"}>}Distinct DAY_DATE) = 1,1,0)

bringing the value of 1 for days Working_Duration>0

and in this 2nd example it will bring the total number of days with Working_Duration>0 aggr per Day, Month
sum(aggr(if(Count({<Working_Duration = {">0"}>}distinct DAY_DATE) = 1,1,0),DAY_DATE,DAY_Month))

[MatheusC · Accepted solution]

@N_avya1 

Did you manage to resolve this topic?

If you have finished, close the topic given the accepted solution.

Thanks!