Excel version of SSRS introduces errors

I have a BAQ report that runs fine in when PDF is the output format, but creates an “error” in the excel file when Excel is the format selected.

The “error” is that a field that calculates to zero, is being displayed as text, with a value 0.000000000000000000.

PDF Output is what is expected:
(the report highlights the line. The red box is the field in question)

The Excel format introduces an error
(the report highlights the line. The red box is the field in question)

the expression of that field is:

=Microsoft.VisualBasic.Interaction.iif(Fields!Part_CostMethod.Value = "A", fields!Calculated_Avg_Total.Value, Microsoft.VisualBasic.Interaction.iif(Fields!Part_CostMethod.Value = "S", Fields!Calculated_Std_Total.Value, Fields!Calculated_Last_Total.Value)) * Fields!PartBin_OnhandQty.Value

We had this problem a while back – it has to do with the format of the cell. Try changing the expression to be:

=(iif(Fields!Part_CostMethod.Value = "A", fields!Calculated_Avg_Total.Value, iif(Fields!Part_CostMethod.Value = "S", Fields!Calculated_Std_Total.Value, Fields!Calculated_Last_Total.Value)) * Fields!PartBin_OnhandQty.Value) * 1.000

If I recall correctly, this forced SSRS to treat the value as a number.

What is your cell format set to for this column?

Adding the * 1.0 to the expression fixed it.

FWIW - The cell format is “Currency”