Summary Method - Multiply/Product

Options
sd12901
sd12901 Member, ALL USERS Posts: 5 New Contributor
in Planning & Modeling

Hi all, 

 

I currently have one line item with 2 dimensions, and the numbers are percentages. I essentially want to strip out one of the dimensions in a new line item but to have all the percentages multiply by each other for the dimension that was taken out. 

 

In simple terms, I'm looking for a 'Summary Method' that multiplies rather than a sum / formula / average etc. 

 

Does anyone know how this can be done? I've attached an Excel which shows what I want to get to in the line item. Apologies if it's something completely obvious. 🙂 

 

Many thanks 

Tagged:

Comments

  • sd12901
    sd12901 Member, ALL USERS Posts: 5 New Contributor

    Hi Misbah, 

     

    The percentages in my current view are all calculated with a formula from other different inputs. The result table formula is the issue I'm having as I'm not sure how to multiply the percentages with the other percentages from the other items in the dimension. 

     

    If there was a 'Multiply' option as a Summary Method for example, that would solve my issue. 

     

    Thanks

  • sd12901
    sd12901 Member, ALL USERS Posts: 5 New Contributor

    Hi @DaanishSoomar, 

     

    Thanks a lot for the detailed explanation and for taking the time to investigate! I do have a lot more items in each dimension than my initial example so I may look to explore a way to not have a long formula. 

     

    If I can't find anything, I may use this example as the list items are unlikely to change regularly and it could just be a one-off long formula to begin with. 

     

    Much appreciated. 

Categories