Using inputsum to calc budget, why is the total budget on pivot table incorrect

[#1]

I'm using a Pivot Table to generate a budget based on last year’s sales. The user enters a growth % (input field) for each product (each row), the budget column is growth  % to last years sales.

Works ok, except the total of the budget column is incorrect.

7,920 * 1.1                  = 8,712        ok      

11,565 * 1.2                = 13,878       ok

Actual Total                = 22,590

Per Table Sum:          23,382         Incorrect

Expressions:

Growth %	inputsum(GrowthPC,'*')
Actual LY	Sum ({$<DataType={'MP_Sales','CG_Sales'},FinYear = {$(vFinYear_LY)}>}$Sales)
Budget	Sum ({$<DataType={'MP_Sales','CG_Sales'},FinYear = {$(vFinYear_LY)}>}$Sales)* (1+Max ({$<xFinYear = {$(vFinYear)}>}GrowthPC)/100)

[nagaiank]

In the Chart properties, set the 'Total Mode' to 'Sum of Rows' for Budget expression.

You may also set the 'Total Mode' to 'No Totals' for the 'Growth %' as the total does not convey any meaningful information.

Hope this helps.