summary method

DMManalili
DMManalili
in Modeling

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

 

 

Tagged:

Best Answer

  • anirudh
    anirudh
    Answer ✓

    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

Answers

  • anirudh
    anirudh
    Hi,

    Try changing the summary method to Sum not Formula

    Regards,
    Anirudh
  • DMManalili
    DMManalili

    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

     

     

     

Categories