Forum Discussion
Percentage Remaining of Amount
I have a SP list with two columns, Budge and Actual - see below. Both columns are data type Currency. I would now like a third column that displays a percentage/progress bar indicating the ...
You can create one calculated column with below formula which can calculate percentage based on Actual and Budget value
=IF(AND(NOT(ISBLANK(Actual)),NOT(ISBLANK(Budget))),Actual/Budget,0)
Make sure that you select Number as return type of the calculated column and also show as percentage.
Now you can use default functionality to show progress bar according to percentage i.e. Column Formatting.
Step 1
Step 2
Step 3 -> Select 1 as maximum number
It will give following output at the end
Hope it will be helpful to you. Please mark this as best response & like if it works for you