Hi experts,
I have a problem with a formula in the Query Designer 7.0. I need to show a text according to a condition:
For example:
X is Variable
Y is a Ratio
Formula:
(( Y >= X * 10) and (Y <= X * 20)) * Here it should show the text: Y is between 10 and 20 + (( Y >= X * 20) and (Y <= X * 40)) * Here it should show the text: Y is between 20 and 40
How can I realize it?
Thank you for your help.