3 Replies Latest reply: Jan 18, 2017 3:59 PM by Stefan Wühl RSS

    Nested IF statements in a Text Object

    Cliff Clayman

      I have a Text Object with an expression in the Text that produces a percentage based on user selections.  I have two selections that I need to test for and each test will use a different set of variables to calculate that percentage.  How can I write the expression to best return the result I am looking for?  Here are the IF statements listed out on their own that I am looking to combine into one large expression.

       

      =If((vFlag) = 'Yes' and Division = 'A', vProjAFYSavings, vFYASavings)

       

      =If((vFlag) = 'Yes' and Division <> 'A', vProjFYSavings, vFYSavings)

       

      =If((vFlag) = 'No' and Division = 'A', vFYASavings, vFYASavings)

       

      =If((vFlag) = 'No' and Division <> 'A', vProjFYSavings, vFYSavings)