Less than the value condition not working in set expression

[its_rajvir]

Dear Experts,

I am trying yo create a measure with Amount less than 20 but i don't know why its not working. I am trying something like this :

Sum({$<TxnType = {'SALE'}, Amount = {"<20.00"}>}CounterSales)

Please Helppp

[mruehl]

Hi,

The expression looks valid for me.

Could you please try:

Sum( { $ < Amount = {"<20"} > } CounterSales )

[Chanty4u]

Try this

Sum({$<TxnType={'SALE'}, Amount={"<=20.00"}>} CounterSales)

[Rohan]

Hi Rajvir,

Kindly check the data type for the Amount Column, is it Numeric or not. If its in string then the range filters wont work in that case.

Regards,

Rohan.

[vincent_ardiet_]

Or are you trying to filter something from which the sum of amount is above 20?