Skip to Content
0

% calculation for Section is not working properly

Jan 31, 2017 at 05:02 PM

59

avatar image

% 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.

10 |10000 characters needed characters left characters exceeded

Can you share the screenshot

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Chaz Pe Feb 01, 2017 at 11:58 AM
0

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.


capture.png (7.5 kB)
capture-2.png (3.1 kB)
Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Feb 01, 2017 at 12:29 PM
0

try this.

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

Share
10 |10000 characters needed characters left characters exceeded