sum(summary()) for groups with varying number of items

983 viewsFormulas and Functions

I have a matrix with groups of items for which I want to do sums. The groups have different numbers of items, so a category won’t work.

Currently,  I create a single forumula for each group. Grp-Yr1.Total = sum(summary(Grp-Yr1)), Grp-Yr2.Total = sum(summary(Grp-Yr2)) etc. Overtime the number of formulas has increased as I’ve added new Groups of items. I’ve thought there should be a way to do this with a single formula. Well, this weekend I tried to do that, without success.

There’s probably a simple way to do this but I couldn’t find it. Does anyone have an answer.

Thanks in advance

The system wouldn’t allow my model to be uploaded so here’s an image of the matrix.

Tahir Answered question July 9, 2023

Hi lyledp, unfortunately, there’s not a straightforward way to do this. You could write a script that created the formulae for you, but not one that would help consolidate them.

It sounds like you’re against it, but you could use a category anyway and allow it to be sparse – just hide the empties.

(PS: We’ve made this a sum(summary()) activity a little easier in the newer version of Quantrix with the introduction of a Summarize functionality, which allows you to hover over the group(s) and click an arrow to automatically add sum(summary()) formulas, either for single groups or across all groups existing in the category. It also serves as a fast expand/collapse functionality. Ctrl + click enables category-wide summarization (add summaries everywhere where it makes sense if they don’t already exist).

lyledp Unselected an answer July 3, 2023

You are viewing 1 out of 4 answers, click here to view all answers.

Latest Questions

Qloud Losing Formatting 4 Answers | 0 Votes
Meditation on timelines 3 Answers | 0 Votes