Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is it possible to show an Expression up on two conditions:
In a table I have a condition on an exspression saying "=mSalesAmount" where mSalesAmount is a variable. Hence, the expression is shown only when the variable equals 1. I would like to attached another condition to the expression (e.g. "=mSalesQty").
Is it possible to make a kind of "and" statement in the conditions? (e.g. "=and(mSalesAmount, mSalesQty)")
mSalesAmount = 1 and mSalesQty = 1 ?
mSalesAmount = 1 and mSalesQty = 1 ?
Ok - that was easy 🙂
Hi Ihan,
So you want the expression as to be
=if(mSalesAmount =1 and mSalesQty =1,1,0)
This can be a way to get this .
Hi Son of Sardar,
As Fantasamagoria suggested I can actually do it without the if()..