Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
i am having the column as below ,
Lesser 90 | Greater 110 | Amount |
500 | 600 | 400 |
600 | 700 | 800 |
700 | 800 | 850 |
800 | 900 | 750 |
i need to write the expression
if the amount is fall under lesser 90 it should display <90%
if the amount is fall under Greater 110 it should display <110
Below is the expected Result:
Lesser 90 | Greater 110 | Amount | Variation |
500 | 600 | 400 | <90% |
600 | 700 | 800 | >110% |
700 | 800 | 850 | >110 |
800 | 900 | 750 | <90% |
Please help me out how to write the expression for this ,Very urgent requirement !.
I'm not getting what you mean by it is not present. Shouldn't it be doing for all rows of data? May be you can provide larger data set and what is your expected output to understand your need bette. In the 4 line sample data you don't have that scenario so it is difficult to interpret your result expectation.