Conditional Expression

[Anonymous]

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?

[surendraj]

May be!!

S_Q - A_Q/A-Q

[sunny_talwar]

Should it be this

(A_Q - S_Q)/A_Q

[MK9885]

S_Q-A_Q as Diff in expression

Diff/A-Q as %diff in expression

[sunny_talwar · Accepted solution]

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)

[Anonymous]

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.

[Anonymous]

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?

[sunny_talwar]

Isn't that we are seeing?

[Anonymous]

Dear Sunny Talwar

I appreciate you.

[Anonymous]

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?