Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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.