Hello,
I'm hoping someone can help me with this problem. It's regarding displaying percentage values on a bar chart.
As my report is setup now,
I have a database field called {yesno} . This field can either be 'yes' or 'no' (obviously haha)
In my stacked bar chart I have in the 'onchangeof' box, "all records".
In the 'show values' box, I have placed 2 formulas:
(1). If {yesno} = 'yes' then 1
(2). If {yesno} = 'no' then 1
Lets say the resultant chart displays a count of 87 for formula1 and a count of 63 for formula2.
My problem is that I want these figures expressed as percentages of the overall total (87+63 = 150)
So one part of the stacked bar will have 58% (87 count) and the other part will have 42% (63 count).
I tried creating running for the counts and then using them in a formula such as:
({#rt1} / {#rttotal}) * 100
and
({#rt2} / {#rttotal}) * 100
but this does not allow me to place these formulas in the chart expert.
Can anyone please help me to get around this problem(?)
Thank you.
J