Multiple IIF Formulas

[laducd]

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))}

[Alex K.]

Hello,

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

Thank you.

[laducd]

I don't understand

[Alex K.]

Hello,

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

Thank you.

[laducd]

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

[Alex K.]

Hello,

Please try to use the following expression:

Code: Select all

{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))}

Thank you.

[laducd]

thanks

[Alex K.]

Hello

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

Thank you.