3 Replies Latest reply: Jan 4, 2017 12:43 PM by Sunny Talwar RSS

    Nested If statement evaluating variable values

    Cliff Clayman

      I have an expression that is evaluating two variable values and giving a up or down arrow based on the outcome.  I need to add another check to this expression to test for another value of a variable.  It is basically an If Then Else, but I'm not sure how to write it and/if there is a cleaner way to do it.

       

      Current Expression:

      If(vCY>vLY, chr(9650),chr(9660))

       

      Added Variable Check:

      If((vFlag) = 'Yes'

       

      Added Expression for above value of 'No':

      If(vPrjCY>vPrjLY, chr(9650),chr(9660))