Only show values if greater than 0.00

jamiemcc — Wed, 30 Mar 2022 13:32:04 GMT

Hi Guys,

I want to write a measure on my set analysis that only brings back values greater than 0.00 to exclude 0 values.

Below is what i currently have but it only brings back 1.00 and 0.00

Sum(Aggr(If(Sum({<YearMonth={'$(vPreviousMonth)','$(vPrevious2Months)','$(vPrevious3Months)'} >}[Total Earnings]) >=0.01 ,1,null()), Roster_Country))

Any ideas.?

Jamie

Re: Only show values if greater than 0.00

Digvijay_Singh — Thu, 31 Mar 2022 00:27:15 GMT

May be you would add Total Earning condition inside the set analysis, not sure though

Sum(Aggr(Sum({<YearMonth={'$(vPreviousMonth)','$(vPrevious2Months)','$(vPrevious3Months)'}, [Total Earnings]={">=0.01"}>}[Total Earnings]), Roster_Country))

topic Only show values if greater than 0.00 in App Development

Only show values if greater than 0.00

Re: Only show values if greater than 0.00