Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get count of field values which are less than selected value of same field.
Hello:
Check the attached App for the similar work around.
Hope this helps,
Narasimha K
I don't think you need the variable. And we may have to decide what to do if more than one or if none are selected. For the sake of argument, I'll go with less than the minimum selected, and 0 if none are selected:
count({<Item={"<$(=min(Item))"}>} Item)
Or if it's a key field:
count({<Item={"<$(=min(Item))"}>} distinct Item)