How do I create a line item percentage

building reports desktopintelligence
1

I need to what percentage that a line of detail is of the total of a section. For example:

line detail#1 10
line detail#2 15
SECTION TOTAL#1 25

line detail#3
line detail#4 …

In the above example I need to show that “line detail#1” is %40 of “SECTION TOTAL#1”.

Does anybody have an idea of what formula to use? :roll_eyes:

ChrisMace (BOB member since 2008-06-02)

2

Hi

line detail#1 10
line detail#2 15
SECTION TOTAL#1 25

Easy way…click on the cell that says 25 and click the “define as variable” button on the left of your formula bar and chose the radio button which says “evaluate formula in its context”

Say A = 25

what you need is 10/A*100

chander165 :us: (BOB member since 2005-12-20)