Ability to create a custom aggregation for table summary row

[jg80]

Just want to cross-post these two other threads on related topic of additional aggregation functionality/controls for the table:

[thread] New Table Feature Announcements

Not sure if this has been split off into another topic, but there are some oddities and some feature requests in the aggregation functionality that would be nice to resolve: Issue: When aggregating by Average, NULL values are interpreted as 0. While possibly valid if a user intends NULL to be interpreted as 0, but usually NULL is meant to be NULL and calculation of average should ignore these records. In other words, average(2, 3, 0, 7) = 12 / 4 = 3 while average(2, 3, NULL and 7) = 12 / 3 =…

Custom Grouped Aggregation

In a table, when grouping by columns, I can select an aggregation type such as sum, which conveniently gives me a total for that group in the "grouped row". However, if I have a column with custom calculations, ex. column c / column d, the grouped row aggregation is calculated incorrectly, no matter what type of aggregation I select. If I don't select an aggregation, nothing shows up. How do I get the grouped row to show the correct calculated aggregated total when columns are grouped? Ex Table …