Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone!
I have this table:
Order no | S_Q | A_Q |
A | 100 | 125 |
B | 200 | 199 |
C | 300 | 280 |
D | 400 | 0 |
E | 0 | 500 |
F | 600 | 400 |
G | 550 | 550 |
I would like to show the difference between S_Q and A_Q that greater than 5% or less than -5%, the answer should be like these:
Order no | S_Q | A_Q | Diff | %diff |
A | 100 | 125 | 25 | 20% |
C | 300 | 280 | -20 | -7% |
E | 0 | 500 | 500 | 100% |
F | 600 | 400 | -200 | -50% |
what is the expression?
And may be this to should only difference above 5% and below -5%
If(fabs((A_Q - S_Q)/A_Q) > 0.05, (A_Q - S_Q)/A_Q)
May be!!
S_Q - A_Q/A-Q
Should it be this
(A_Q - S_Q)/A_Q
S_Q-A_Q as Diff in expression
Diff/A-Q as %diff in expression
And may be this to should only difference above 5% and below -5%
If(fabs((A_Q - S_Q)/A_Q) > 0.05, (A_Q - S_Q)/A_Q)
Hi Sunny Talwar
no it does not work!
It shows the all data but I want to show only the differences which are obey the condition.
Hi again!
It works; the only task to do is that it shows all data and in this situation I would not like to show the B,D and G.
who we can do it?
Isn't that we are seeing?
Dear Sunny Talwar
I appreciate you.
Hi Sunny Talwar
Can you look at this?
Order no | (A_Q - S_Q) | If(fabs((A_Q - S_Q)/A_Q) > 0.05, (A_Q - S_Q)/A_Q) |
- | - | |
A | 25 | 20.00% |
B | -1 | - |
C | -20 | -7.14% |
D | -400 | - |
E | 500 | 100.00% |
F | -200 | -50.00% |
How to remove columns B AND D?