Only show values if greater than 0.00

[jamiemcc]

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

[Digvijay_Singh]

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