Forum Discussion
Solved
Visual calculation dispalay as a %
Hi, I tried to use visual calculation for the first time. To calculate percentage of a parent. The problem I have is that displayed value is 1 or 0.94 and similar where I would want value dispalyed...
Justas4478 Ah yes then you need to use "0.0%" instead of "Percent"
Percent of parent = FORMAT(DIVIDE([Sum of Column1], COLLAPSE([Sum of sum], ROWS)), "0.0%")
daircom It works.
I tried to do decimal places format to 1 decimal space, but it does't work for some reason.
Can decimal formating then be added to this formula in some way?
Justas4478 Ah yes then you need to use "0.0%" instead of "Percent"
Percent of parent = FORMAT(DIVIDE([Sum of Column1], COLLAPSE([Sum of sum], ROWS)), "0.0%")