Error: Garbage after expression

[zhbuyiqlik]

I created a pivot table that displays sales across different dimension.  I wanted to put the total sales on top of the sheet.  So I created a measure called Total Sales=Sum(Sales) and threw on to the top of the sheet.   The total is correct as I checked and it changes in response to all kinds of filtering.  But there is a message saying "Error: Garbage Over Expression" on the total Box. 

Don't know why.

Thanks

Message was edited by: Buyi Zhang

[dwforest]

Any row of data not have a numeric value for Sales?

[zhbuyiqlik]

No, they are all numeric.

[Thiago_Justen_]

Make sure your Sales data is numeric. You can also try something like this:

Sum(Num#(Sales))

[Thiago_Justen_]

Could you please take a snapshot of the screen with expression?

[Anil_Babu_Samineni]

Screenshot please?

[zhbuyiqlik]

This did not work

[zhbuyiqlik]

Top right corner

[zhbuyiqlik]

Top right corner.  Thanks

[Anonymous]

If you are trying to start with a text concatenated with an expression you need to have it in this format:

="Total Sales = "&Sum(Sales)

That might fix the expression!