Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
75 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |