aggr,range sum functions with set analysis

[grajmca_sgp123]

Hi all,

how do we write this if condition by using set anlysis

if(BS= 'P',sum( aggr( rangesum( above( sum([val]),0,12)),YearMonthNumber)))

Thanks in adavce

[petter · Accepted solution]

If you had some more context to it I might be more sure if this is a correct solution - but I guess:

Sum( Aggr( RangeSum( Above( Sum( { < BS={'P'} > } [val]) , 0 , 12 ) ) , YearMonthNumber ) )