Percentage Remaining of Amount

Iron Contributor

I have a SP list with two columns, Budge and Actual - see below. Both columns are data type Currency.


Screenshot 2022-08-04 145614.png

I would now like a third column that displays a percentage/progress bar indicating the Actual amount that has been spent of the Budget amount. In this case it would be 28.19%


How can I achieve this?

1 Reply



You can create one calculated column with below formula which can calculate percentage based on Actual and Budget value






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