Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can some one help to write the expression :
if(name= 'RISK',RangeMin(0,aggr(rangesum(above(sum([sales_plan]), 0, rowno())), [Fiscal Month]) - aggr(rangesum(above(sum(projected_adjustment_unit),0, rowno())),[Fiscal Month])),
My risk should be calculated against [Fiscal Month] and [year].
when I am writing it with aggr function like this , its having result but taking all [Fiscal Month] and [year]
if(name= 'RISK',rangesum(above(sum([sales_plan]), 0, rowno())) - rangesum(above(sum(projected_adjustment_unit),0, rowno())),
share data sample
See the RISK calculation in expression.