topic Number Of Days With Working Duration >0 in App Development

Number Of Days With Working Duration >0

N_avya1 — Fri, 15 Nov 2024 21:14:27 GMT

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)

Re: Number Of Days With Working Duration >0

MatheusC — Tue, 21 Nov 2023 13:12:29 GMT

@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))

Re: Number Of Days With Working Duration >0

MatheusC — Wed, 22 Nov 2023 11:37:11 GMT

@N_avya1

Did you manage to resolve this topic?

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

Thanks!