Sum if One column value is greater than other

[RishabhTFC]

Hello

I am stuck in a problem where I have to find the Sum(sales) in a KPI, I want those sum from sales whose sales value is not greater than forecast.

Models	Forecast	Sales	Adjusted Forecast
MD-1	97	65	32
MD-2	79	14	65
MD-3	41	6	35
MD-4	51	60	0
MD-5	12	10	2
MD-6	40	55	0
Output Coming	Sum(Sales)	210
Output Wants	Sum(Sales)	95

can anybody help me with that

Thanks

RM

[sunny_talwar]

Try this

Sum({<Models = {"=Sum(Sales) < Sum(Forecast)"}>} Sales)

[Frank_Hartmann]

see attached qvw.

hope this helps

[sunny_talwar]

Frank - 

Checking it against Forecast is not a good idea here. What if we have two forecast numbers which are same but with different sales? I think checking it against Models make more sense here.