I am trying to find a way to present the difference between current progress% and previous progress % (in a custom field) with a structure formula.
Currently I have this formula for a percentage column;
if Progress and Previous_progress: (Progress/Previous_progress)/100
But the problem is that for example in a case when the
-> formula returns 1% and what I would want it to return is 0%
And in a case when:
-> the formula should return 5%
Any ideas on how to solve this would be greatly appreciated!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.