Skip to Content
avatar image
Former Member

% calculation for Section is not working properly

% calculation for Section is not working properly

Hi There, I am using the formula =([Total Cost]/Sum([Total Cost] ForAll ([Dimensions from the block]))*100 in section, but for some reason I am not getting the right percentage in webi. Can some one please help with formula to calculate percentage on Section in webi. Thank you.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 01, 2017 at 11:58 AM

    Hi Amit,

    Please see attached of what I get in report and what I get when I do in Excel. I've also included Excel formula.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 01, 2017 at 12:29 PM

    try this.

    =Sum([Total Cost])/Sum([Total Cost]) ForAll ([Your section object])*100

    Add comment
    10|10000 characters needed characters exceeded