Help with nested formula

[laducd]

Hi
The formula below is not working, any help would be greatly appreciated

{IIF(ABS(Settlement_Trading.Trade_Amount_in_millions_Sum)>1,(IIF(Settlement_Trading.Trade_Amount_in_millions_Sum==Settlement_Trading.Forecast_Trade_Amount_in_millions_Sum,0,ABS((Settlement_Trading.Trade_Amount_in_millions_Sum-Settlement_Trading.Forecast_Trade_Amount_in_millions_Sum)/Settlement_Trading.Trade_Amount_in_millions_Sum))))," "}

[laducd]

I'm also trying this

{IIF(ABS(Settlement_Trading.Trade_Amount_in_millions_Sum)<1," ",ABS((Settlement_Trading.Trade_Amount_in_millions_Sum-Settlement_Trading.Forecast_Trade_Amount_in_millions_Sum)/Settlement_Trading.Trade_Amount_in_millions_Sum))}

[Alex K.]

Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.