I have a repeating group listing all of a particular thing.
The things have two fields; each is numeric; Field A and B.
You want to show only the things where A > B.
How do you do that?
I’m displaying the items in a repeating group. I’m searching for all things of this type and want to constrain the data, comparing one field to another within each thing.
When you create your thing and assign a number to A and B, you should also create another field (in this case I’ve called it AB) which is the sum of A minus B.
Now, you know that if AB is a negative number then B > A. If AB is a positive number then A > B. Finally, if AB is zero, then you know A = B.
Then you can set up the following constraint on your repeating group:
If A and B are values that are going to change through usage of the app, then just remember to recalculate AB each time you change A or B. It’s only 1 extra step in each workflow.