Exporting to Excel Total Column is not correct, only when exporting to pdf.

[donalexander]

Hello

Custom Code

Public Shared Value as Integer=0Public Shared Function GetValue(Item as Integer) as Integer


value= value + Item

return Item

End Function

Public Shared Function GetTotal()

return value

End Function

On the row to store the numbers I here is my code -
=Code.GetValue(IIF(IsNothing(Lookup(Fields!CustomerName.Value, Fields!Customer_Name.Value, Fields!BudgetPeriod.Value, "DataSetSQL_Budget")),0, Lookup(Fields!CustomerName.Value, Fields!Customer_Name.Value, Fields!BudgetPeriod.Value, "DataSetSQL_Budget")))
Finally on the total row I input the total using
=Code.GetTotal()

Now it works perfect I can see the totals on the screen and print it on pdf perfectly, but when exporting to Excel the total is incorrect. I believe it has to do something with pages in Excel. Any help will be appreciate. Thank you in advance.