Percentage Remaining of Amount

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

@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.

 

kalpeshvaghela_0-1659688338183.png

 

Now you can use default functionality to show progress bar according to percentage i.e. Column Formatting.

 

Step 1

 

kalpeshvaghela_1-1659688399731.png

 

Step 2

 

kalpeshvaghela_3-1659688451596.png

 

 

Step 3 -> Select 1 as maximum number

 

 

kalpeshvaghela_4-1659688473600.png

 

It will give following output at the end

 

kalpeshvaghela_5-1659688507585.png

 

Hope it will be helpful to you. Please mark this as best response & like if it works for you