Method:Classic General Q&A

Re: Grid subtotals in calculations

Anonymous — Tue, 12 Mar 2013 14:16:33 GMT

bcr_garrett:

Is there any way to add other functions to these dynamically created "rows." I would like to be able to average a column instead of subtotaling - but keep it in the grid for ease of exporting and printing if necessary.
Any suggestiong?

Hi Garrett,

Only subtotals may be part of the grid itself. You can certainly calculate an average for a grid's column, however that would need to be displayed elsewhere on the screen such as within a label or a textbox. The other alternative is creating a custom report that will display the values exactly as you see fit. You'd still need to develop the action logic to loop through each row in the grid to count them, create a sum, and then calculate the average to output.

-Angelo

Re: Grid subtotals in calculations

bcr_garrett — Mon, 11 Mar 2013 22:11:56 GMT

Is there any way to add other functions to these dynamically created "rows." I would like to be able to average a column instead of subtotaling - but keep it in the grid for ease of exporting and printing if necessary.
Any suggestiong?

Re: Grid subtotals in calculations

Method_Michael — Tue, 27 Sep 2011 19:15:42 GMT

JKM@SA,

The grid subtotals are dynamically calculated and are not actually fields but you can use the Get Sum action, to get the sum of a column in a grid.

So in this case use the get sum action and get the first total, use another get sum and get the second total and then divide those and put it onto a field on the screen. You may even want to place these actions in the After Update or After edit actions of a grid.

-Michael

Grid subtotals in calculations

JKM@SA — Tue, 27 Sep 2011 17:24:46 GMT

Is there are way to use grid subtotals to calculate a field? If so, how do I find out the names of the subtotal fields?

For example, if I wanted to calculate estimated revenue per hour in a work order, first I would add a field EstRevPerHour. Then I would want to take the Amount subtotal from the Tasks & Materials grid and divide it by the Est Hrs subtotal. I know how to set up the Action to do the Basic Math Calculation. I just don't know the names of the subtotal fields so I can reference them.