Aug 04 2022 06:59 AM
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?
Aug 05 2022 01:35 AM - edited Aug 05 2022 02:42 AM
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