Issue with creation of calculated columns

[Anonymous]

 Hello friends, 

 I am a little changing my question because a few hours ago I didn't phrase it correctly and therefore didn't receive the replies that were matching my question. 

 I am trying to created two calculated columns. 

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 am getting some weird symbols or 0s. Does someone know how to fix it?

Please let me know. 

Thank you.

[Anonymous · Accepted solution]

Hi  @Anonymous ,

When any number is divided by 0, the result will become 0, and when 0 is used as the denominator, infinity will appear.

If you want to display %, [Forecast over actuals] can choose Column tools-choose%

If the column [Actuals over forecast] also wants to be displayed as 0, it can be replaced by a formula:

Actuals over forecast =
DIVIDE([TOTAL FCST] ,[TOTAL HISTORY],0)

Select Column tools-select%

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , based on what I got so far.

Add a visual level filter of item, then use TOPN , 10 and variance as measure and filter