Need Help with IF AND statement

[Anonymous]

Hi All,

I need some help with an IF AND statement for my chart expressions . I have two
fields where I want to sum the amount if it meets the criteria. To put it in
words, IF Description=”EMV” AND Amount=0, then  Sum everything in the Amount field  Else Description=”EMV” AND Amount >0, Sum
just the SELL field.

See below example.

#1

Description	Amount
Buy	-1,000
Sell	600
Interest	260
EMV	0
	-140

Want to return the sum of amount -140

#2

Description	Amount
Buy	-1,000
Sell	600
Interest	260
EMV	500
	360

Want to return just the Sell for 600

Any inputs will be greatly appreciated.

Thanks,

Frank

[Anonymous]

Digvijay , Ankit , and Andrei. Thanks all for the help!.