Issue with calculated columns

[Anonymous]

Hello everyone, 

 I am trying to create two calculated columns namely Difference between forecast over actuals

Forecast over actuals = [TOTAL HISTORY] / [TOTAL FCST]

Difference between actual over forecast

Actuals over forecast = [TOTAL FCST] / [TOTAL HISTORY]

For some reason instead of difference (ideally in I want to get the result in %) I am getting some weird symbols or 0s. Does someone know how to fix it?

Please let me know. 

[Anonymous]

@Anonymous 
I also wonder how did you make the column box line disappear. 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Greg, thank you. Do you know how I can make it in %?

[Greg_Deckler]

@Anonymous Select the column in either Report or Data view and then in Column Tools in the ribbon, click the % button.

[Greg_Deckler]

@Anonymous Dividing by zero will do that. Try DIVIDE([TOTAL FCST],[TOTAL HISTORY],0)