Forum Discussion

jonboylib's avatar
jonboylib
Iron Contributor
Aug 04, 2022

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

 

How can I achieve this?

Lists
SharePoint Online

1 Reply

Sort By
  • kalpeshvaghela's avatar
    kalpeshvaghela
    Steel Contributor
    Aug 05, 2022

    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

     

     

     

     

     

Resources