Skip to Content
0
Former Member
Apr 16, 2010 at 01:46 PM

Formula in Query Designer

23 Views

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.