Add a custom formula for summary that doesn't necessarily apply to rest of cells in that line item

Description of the enhancement required:

The ability to add a customized formula for the summary that does not necessarily apply to the rest of the rows within that line item (currently the formula for the line item becomes the formula for the summary if you are to select the "Formula" summary option).


How would it help the business process:
We would like to have a summary that is a weighted average of the values within the column. Unfortunately, since the line item summary is limited to a few options, we can't present a weighted average in one step within the same column. If you were to enable the formula option to function as it does today, but to also allow the user to apply a custom formula, that would be very helpful as it would allow us to include a formula that calculates the weighted average as a summary.

19 votes

In Review · Last Updated


Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!