
Creator
2024-01-16
01:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
557 Views
4 Replies

Partner - Specialist
2024-01-16
02:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
The expression looks valid for me.
Could you please try:
Sum( { $ < Amount = {"<20"} > } CounterSales )
Manuel Rühl
www.mamaconsulting.de
www.mamaconsulting.de
534 Views

MVP
2024-01-16
03:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this
Sum({$<TxnType={'SALE'}, Amount={"<=20.00"}>} CounterSales)
519 Views

Partner - Specialist
2024-01-16
07:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
497 Views

Specialist
2024-01-16
08:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or are you trying to filter something from which the sum of amount is above 20?
495 Views
