Percentage Remaining of Amount

[jonboylib]

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 Actual amount that has been spent of the Budget amount. In this case it would be 28.19%

How can I achieve this?

[#2]

@jonboylib 

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