Hi Iruff and John M,
John, thanks for the response. That would work, but I'll suggest an approach that calculates the total without having to manually change the filter.
Iruff, I suggest having Method actions calculate these numbers. You can have these run from the screen's OnScreenLoad, or anywhere else that makes sense for you. The actions you would use are:
- Assign Value to Action Result - create an action result to sum Flats, initialize it by setting the action result to 0
- Assign Value to Action Result - create an action result to sum Corners, initialize it by setting the action result to 0
- Start Loop Through Grid
- Start Conditional Statement - compare the Value From Row in your Description column, equal to Liberty Flats
- Baic Math Calculation - increment the sum by adding the value from row Total FT column to the Flats action result
- End Conditional Statement
- Start Conditional Statement - compare the Value From Row in your Description column, equal to Liberty Corners
- Baic Math Calculation - increment the sum by adding the value from row Total FT column to the Corners action result
- End Conditional Statement
- End Loop Through Grid
- The last action(s) will display the 2 sums in whatever way you would like. For example, you could assign each action result to a label displaying the totals.
The idea here is that these actions will loop through the grid, compare each description, and increment whichever sum is applicable. Hope this helps, please let us know if you have any questions about this.
-Russell