
Re: Pie Chart with multiple formulas
Liron Baram Aug 15, 2013 8:28 AM (in response to Hannes Peiffer )actualy
it quite easy
just build a chart with no dimensions and only expressions
and the pie will work automaticlay

Re: Pie Chart with multiple formulas
Stefan Wühl Aug 15, 2013 8:29 AM (in response to Hannes Peiffer )Your three expressions look like
=sum(Value1)
=sum(Value2)
=sum(Value3)
right?
Then maybe just divide each by the sum of the three:
=sum(Value1) /
rangesum(sum(Value1),sum(Value2), sum(Value3) )
...

Re: Pie Chart with multiple formulas
Hannes Peiffer Aug 15, 2013 8:56 AM (in response to Stefan Wühl )
Re: Pie Chart with multiple formulas
Stefan Wühl Aug 15, 2013 9:50 AM (in response to Hannes Peiffer )Sorry, I don't really get it.
You've got three expressions like this
Label: Lohnkosten
Exp: =sum(Lohnkosten)
Label: Maschinenkosten
Exp: =sum(Maschinenkosten)
Label: Materialkosten
Exp: =sum(Materialkosten)
Change your expressions to:
=sum(Lohnkosten) / rangesum( sum(Lohnkosten), sum(Maschinenkosten), sum( Materialkosten) )
=sum(Maschinenkosten) / rangesum( sum(Lohnkosten), sum(Maschinenkosten), sum( Materialkosten) )
=sum(Materialkosten) / rangesum( sum(Lohnkosten), sum(Maschinenkosten), sum( Materialkosten) )
It's quite hard to tell what your issue may cause, without knowing anything, and a screenshot is only marginally helpful.
Could you post a small sample app?

Re: Pie Chart with multiple formulas
Hannes Peiffer Aug 15, 2013 9:58 AM (in response to Stefan Wühl )Hi,
here is the sample app with the three expressions and the error

Sample Data.qvw 1.8 MB

Re: Pie Chart with multiple formulas
Stefan Wühl Aug 15, 2013 10:18 AM (in response to Hannes Peiffer )
Re: Pie Chart with multiple formulas
Hannes Peiffer Aug 15, 2013 10:17 AM (in response to Stefan Wühl )That's funny. I changed the number format to percent, but the error still occurs. But the way is right that I programmed the pie chart? I work with 11.2 SR2.




