Problem with set analysis

[geogou1973]

Hello.

I'm facing a problem with a command in set analysis. I have the following command

=sum({<DATE_ID={'>=$(=previousudate)<=$(=vudate)'},DEL_ITEM={'DEL_ITEM'}>} AMOUNT)

How can I complete the formula to have only values that the sum of the amount is less than 5.000

Thank you in advance

[tamilarasu]

I am bit confused about the OP's requirement whether it is <5000 or <=5000. Lets wait for the reply.

gou geo wrote:

                 The formula is working correctly for the items that the amount for example is less than 5000 but at the same time I have a lot of items with amount 5000 that is not correct

[tamilarasu]

Sunny,

While replying to you, the thread has been closed. This is what happened many times when I use my phone to reply. Very hard to reply. Any way, he got the solution.