Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
May be this:
If(vFlag = 'Yes',
If(vCY>vLY, Chr(9650), Chr(9660)),
If(vPrjCY>vPrjLY, Chr(9650), Chr(9660)))
What happens when vFlag = 'Yes'? May be something along these lines
If(vFlag = 'Yes', SomeExpressionOrValue,
If(vPrjCY>vPrjLY, chr(9650),chr(9660)))
If the vFlag = 'Yes', then the current expression is used.
May be this:
If(vFlag = 'Yes',
If(vCY>vLY, Chr(9650), Chr(9660)),
If(vPrjCY>vPrjLY, Chr(9650), Chr(9660)))