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
