Expression calculation for PIE chart is wrong

[amber2000]

Hello Boys and Girls,

I'm having a problem with an expression.

In my table most of the fields are expressions with subtotals on top and the calculations are correct.

However if I make a PIE chart from the data something is going wrong, I want to have a total value of 100% in the pie.

It's a rather difficult calculation and I've tried many options but nothing I do gives me the correct values.

As a result I want the value of each record from field #Absolute divided by the subtotal of that field.

I'm attaching a small example so It's easyer to understand what I'm trying to do, The Column "TEST_Juist_Waardes" are manualy fixed by myself and it's these results I want to see in the Pie.

Is this even possible?

Kind regards,

Monique  

[m_woolf]

Try taking out the "/100" from your expression and then check the Relative box

[jerem1234 · Accepted solution]

Hi Amber,

    I used the formula:

sum([#Absolute])/ Sum(total #Absolute)

Please find attached as well.

Hope this helps!

[MK_QSL]

Use below expression

NUM(sum({$<[ReasonCode_Desc]={"*"}>} [#Absolute])/sum(TOTAL {$<[ReasonCode_Desc]={"*"}>} [#Absolute]),'#.##0.00%')