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