Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Amber,
I used the formula:
sum([#Absolute])/ Sum(total #Absolute)
Please find attached as well.
Hope this helps!
Try taking out the "/100" from your expression and then check the Relative box
Hi Amber,
I used the formula:
sum([#Absolute])/ Sum(total #Absolute)
Please find attached as well.
Hope this helps!
Use below expression
NUM(sum({$<[ReasonCode_Desc]={"*"}>} [#Absolute])/sum(TOTAL {$<[ReasonCode_Desc]={"*"}>} [#Absolute]),'#.##0.00%')