I have a small problem where the above image is correct and the chart below is wrong. The column labeled Projected 2014 should match on both. I am using an InputSum with a variable on the top for the What If column (all calculations on the top are correct). The bottom chart I use the same calculation however it's doing the calculation on the total line also. Is there a way to only use the detail lines for the chart and ignore the total?
Here is the calculation I am using on both:
sum({} [In company code currency_HSL] * -1) + sum({} [In company code currency_HSL] * -1) * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1) * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1) * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1) * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1) * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1) * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1) * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1) * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1) * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1) * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1) * InputSum(vPCT) + sum({} [In company code currency_HSL] * -1) * InputSum(vPCT)
![P3.png](/legacyfs/online/59406_P3.png)
![P4.png](/legacyfs/online/59405_P4.png)