Measure Expression Not Limiting To Positives In Pivot Table

newuser — Mon, 23 May 2022 18:19:55 GMT

In a pivot table, the following expression is not limiting to positive values. Any idea why? The plain text is also below; screenshot with cleaner formatting follows. The pivot table column is Year_Placed. The rows are a different (higher-level) field.

sum( aggr(if(

(sum( if( Month_Placed <= CurrMonth /*and Year_Placed = CurrYr*/ and placedt_all=aggr( nodistinct
max( if(Month_Placed <= CurrMonth /*and Year_Placed = CurrYr */, placedt_all)),acctpol, Year_Placed), Placed))
+
sum( if( Month_Placed <= CurrMonth /*and Year_Placed = CurrYr*/
and placedt_all=aggr($ nodistinct
max( if( Month_Placed <= CurrMonth /*and Year_Placed = CurrYr*/, placedt_all)),acctpol, Year_Placed) , Adjustment))) > 0,

sum( if(Month_Placed <= CurrMonth /*and Year_Placed = CurrYr*/ and placedt_all=aggr( nodistinct
max( if( Month_Placed <= CurrMonth /*and Year_Placed = CurrYr*/, placedt_all)),acctpol, Year_Placed), Placed))
+
sum( if( Month_Placed <= CurrMonth /*and Year_Placed = CurrYr*/
and placedt_all=aggr( nodistinct
max( if( Month_Placed <= CurrMonth /* and Year_Placed = CurrYr*/ , placedt_all)),acctpol, Year_Placed) , Adjustment)), 0), acctpol, Year_Placed))

Re: Measure Expression Not Limiting To Positives In Pivot Table

newuser — Mon, 23 May 2022 19:34:39 GMT

I think I figured it out. The AGGR "group by" fields needed another field (one of the higher-level fields I was using as my pivot table row dimension). Once I added that higher-level field, the positive value criteria in the IF statement worked.

topic Measure Expression Not Limiting To Positives In Pivot Table in App Development

Measure Expression Not Limiting To Positives In Pivot Table

Re: Measure Expression Not Limiting To Positives In Pivot Table