Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
The expression looks valid for me.
Could you please try:
Sum( { $ < Amount = {"<20"} > } CounterSales )
Try this
Sum({$<TxnType={'SALE'}, Amount={"<=20.00"}>} CounterSales)
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.
Or are you trying to filter something from which the sum of amount is above 20?