I'm using Project Online and am trying to create a custom calculated column which shows me the percentage difference between my "Actual Cost" and a custom column called "Profitability".
I'm having issues with the calculations actually working, and I feel like there's a bigger issue here than just the syntax of my formula.
For reference, it is:
(([Actual Cost] / [Profitability] * 100) & "%")
After I created the column, I tried to get it to return a value and it wasn't returning anything at all, I broke it down even further to just:
[Actual Cost] / [Profitability]
Still nothing, I even went further and tried to return the value of a column:
[Actual Cost]
No dice. I then tried to do a basic calculation (11*19), and even that wasn't returning a value. I checked my project out, re-published it and checked it back in to see if it I needed to force a re-calculation and that didn't help at all.
Can anyone provide any insight? I feel like there's a background issue that I'm not seeing here, and given how limited PWA is to diagnostics I'm not too sure where I should be looking.
Thanks!