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

982 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

Lyndsey, thanks for the quick response. Not the answer I was hoping for, but not unexpected either.

I had thought @level() would work. @level(B,1) retrieves the correct group name and I thought that could be used in the formula. But when used within the formula on the right side it throws a general syntax error that doesn’t identify the location in the formula of the error. When used on the left side there’s no error but it doesn’t produce any results either.

I’ve enclosed an image of a simpler model showing these attempts.

lyndseyweber Edited comment July 3, 2023

Lyle – Right, I see what you are trying to do – unfortunately as you know, @level() and other functions (outside of recursion) don’t work on the left side of the formula. We have gotten this request in the past, though – I’ll be sure to echo it again to the product team. I’m sorry I don’t have a better answer for you! – Lyndsey

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