Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
its_rajvir
Creator
Creator

Less than the value condition not working in set expression

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

Labels (5)
4 Replies
mruehl
Partner - Specialist
Partner - Specialist

Hi,

The expression looks valid for me.

Could you please try:

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

Chanty4u
MVP
MVP

Try this

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

 

Rohan
Specialist
Specialist

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_
Specialist
Specialist

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