summary method

Hi, question please. How can I sum up #transactions #1-#5 without adding the top list (alo world)? The total should only be 249 but the values is 5,772. I already edit the summary method to formula. Thank you.

Accepted answers

anirudh

Try changing the formula to IF PARENT(ITEM('CFO Highlights....')) = 'CFO Highlights....'.Alo World THEN 1 ELSE 0
That should work!

Although I have to say, this kind of hardcoding is almost never a good idea. Do consider using another approach...

Regards,
Anirudh

All comments

anirudh

Hi,

Try changing the summary method to Sum not Formula

Regards,
Anirudh

DMManalili

Hi, I changed the summary method to SUM, it got result however the values for the ALO world changed to zero value.

I tried to do a test IF item(list.alo world) condition here but got an error, maybe because the list that I used in my module has a parent list. see ss:

here are my dimensions:

here is the list:

anirudh

Quick Links

Can you help?

Unanswered questions

How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
How to use Client ID and Client Secret for API request directly?
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
New UX Filtering for Hierarchy sibling
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context and…