Need help expression syntax

[#1]

Hi,

So far I have

if(sum(TXN_COUNT) < 11 ,sum(TXN_COUNT))

which mostly does what I need it to do. I need to do something like

if(sum(TXN_COUNT) < 11 and SYS_ID in 'WIRES_ONLINE', 'ADVANCES_ONLINE', sum(TXN_COUNT))

This isn't the correct syntax but I need to show the sum of TXN_COUNT only when the SYS_ID is either one of those 2 values.

Any help would be greatly appreciated.

[#2]

Try this:

if(sum(TXN_COUNT) < 11, sum({$<SYS_ID={'WIRES_ONLINE','ADVANCES_ONLINE'}>} TXN_COUNT))

[#3]

Thanks - this is perfect!