How to sum the value for specific date range?

[Anonymous]

Hello Anyone;

      I am attempting to get values sorted by payment type for a range per the chart below.

I am not sure if i should be using a set analysis or not.  Below is the function i am using to try and get transactions from 0 - 2500, however I keep getting nothing back.  2501 to 10000 is just a sum([Amt Paid]).  Can anyone point me in the right direction?

Thank you in advance for any assistance.

=If([Amt Paid] >= 0 and [Amt Paid] <= 2500, sum([Amt Paid]))

[Digvijay_Singh · Accepted solution]

May be this -

Sum({<[Amt Paid] ={">0<2500"}>}[Amt Paid])

[Anonymous]

Thank you!!!!!!!!!!!!!!!

Is this a set analysis?

[Digvijay_Singh]

Yes!