Forum Discussion

Karen356's avatar
Karen356
Copper Contributor
May 04, 2023

Calculated Column?

Hi everyone

I am hoping that you can help me with a lists issue I have: 

 

I have been given an Excel Spreadsheet - collating petrol vouchers provided to clients.  

I think I need to use a calculated column to collate the running balance.

 

I have the following columns:

[Credit] - which is taken off the [Running Balance]

[Debit] - which is added to the [Running Balance]

 

As the column can't reference itself, I think I will need to create another column for the calculations?  

Lists
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    MVP
    May 08, 2023

    Karen356 Here's Microsoft official documentation for your reference:

     

    SharePoint Calculated Field Formulas 

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    May 08, 2023

    Karen356 If you want difference between Credit and Debit column values from same list item/row, you can use calculated column in SharePoint with simple formula like: 

     

    =[Credit]-[Debit]

     

    Note: You cannot read column value from other rows/list items in calculated column formula.

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

    For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Resources