Creating reports and dashboards | Stimulsoft community forum

I'm looking for an IIF Formula where if a value is not equal to 0 give me a value, the next if formula will say if this equals 0 give me this.

{IIF(Actual_Opening_Balance.Month_2_of_Current_Quarter_Actual_Opening_Balance_Plan_Sum<>=0,Actual_Opening_Balance.Month_2_of_Current_Quarter_Actual_Opening_Balance_Plan_Sum+Net_2.Month_2_of_Current_Quarter_Actuals_Sum,IIF(Net_2.Month_2_of_Current_Quarter_Actuals_Sum==0," ",Actual_Opening_Balance.Actual_2_Quarters_Prior_Sum+Net_2.Actual_2_Quarters_Prior_Sum+Net_2.Month_1_of_Current_Quarter_Actuals_Sum+Net_2.Month_2_of_Current_Quarter_Actuals_Sum))}

Hello,

Please try to use the "!=" operator for checking by zero.

Thank you.

I don't understand

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details?

Thank you.

My formula is not working, returns blank data. Is there something wrong with my formula

Hello,

Please try to use the following expression: Thank you.

thanks

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.