summary method

Highlighted
Contributor

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.

 

DMManalili_0-1600497134151.png

DMManalili_1-1600497356653.png

 

 

3 REPLIES 3
Highlighted
Master Anaplanner/Community Boss

Re: summary method

Hi,

Try changing the summary method to Sum not Formula

Regards,
Anirudh
Highlighted
Contributor

Re: summary method

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

DMManalili_0-1600523551847.png

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:

DMManalili_1-1600523646811.png

here are my dimensions:

DMManalili_2-1600523707645.png

here is the list:

DMManalili_3-1600523725231.png

DMManalili_4-1600523862687.png

 

 

 

Highlighted
Master Anaplanner/Community Boss

Re: summary method

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