aggr(if() expression not working

[surajdhall]

Hi All,

I have an aggr expression in pivot table(in dimension) to calculate trend for all the months in. My expression works to show bad trend, but not in other as per the conditions below.

The below expression is test column in table, it gives value 1 for down trend and 0 for up and horizontal trend, so the test is successful, but my main expression is not working.

if(not IsNull(Trim(After(sum(Budget)/sum(Sales)))),

If(round(Alt(After(Sum(Budget)/Sum(Sales)), 0),0.0001) <

  (Round(Alt(Sum(Budget)/Sum(Sales), 0),0.0001) - (Round(Alt(Sum(Budget)/Sum(Sales), 0),0.0001)*0.005)),1,0),0)

Please help!