Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@DIFF1
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.
Greg, thank you. Do you know how I can make it in %?
@DIFF1 Select the column in either Report or Data view and then in Column Tools in the ribbon, click the % button.
@DIFF1 Dividing by zero will do that. Try DIVIDE([TOTAL FCST],[TOTAL HISTORY],0)
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |