Expressions

[#1]

Hello,

I am using this expression with a Text Object.

= num (sum({<[Open Collections Loss Type]={'Chargeback'},[Open Collections Date]={'1/19/2016'}>} [Open Collections Amount]), '$##,###.##')

This has worked fine. My issue though, I would like to use other items such as 'Deposit' too add along with chargeback.

Also, with my date I would like to use a range i.e. 1/1/2016- 1/19/2016.

Thank you,

Manny

[sunny_talwar]

Try this:

=Num(Sum({<[Open Collections Loss Type]={'Chargeback', 'Deposit'},[Open Collections Date]={'>=1/1/2016<=1/19/2016'}>} [Open Collections Amount]), '$##,###.##')