Expression help

[#1]

Need to calculate value of subject 2 where  class is B and subject 2 is greater then Subject A

S.no	Subject1	Subject2	Class
1	520	6175	A
2	315	1400	B
3	623	445	C
5	25	45	A
6	225	702	B
7	3654	1512	C
8	4005	13350	A
9	1575	3060	B

[#2]

Hi,

Try this expression " Sum({<Class={'B'}>} IF(Subject2>Subject1,Subject2)) ". Hope this will help.

Thanks,

Srini.

[#3]

what's wrong with dis expression:

Sum(({<Status={'In Progress'}>}if(Sum([Act Value])>(Sum([Est Value])*0.9),Sum([Act Value])))

[#4 · Accepted solution]

There were some syntax and logical error.

This is same as what i have suggested earlier. Just replace class with status, Subject 2 as Actuals and Subject1 as Est Value.

Sum({<Class={'B'}>} if(Subject2 >((Subject1)*0.9) ,Subject2))