How to calculate Sum of Column values-Master value RRS feed

  • Question

  • Hi,

    I have a List Called Travel Tracker in sharepoint-2013, which gets entered when a person travels in an organization . It has a column called Expenditure, which stores the cost of the travel.

    I need a view in the list with the following columns

    • Total Budget(Currency Value, Need to store some where else in the same list/other list/same site)
    • Total Cost(Sum of all the Values of Expenditure column)
    • Remaining Budget(Total Budget-Total Cost)

    Challenges I faced

    • Where Should I store the value Total Budget 
    • How can I sum one column values. ofcourse We have totals in view settings but that displays on top/at bottom of the column.
    • How to write the formula for Total Budget-Total Cost, unless I get Total Cost in a column.

    Please guide me in this regard.

    Monday, March 9, 2015 7:14 AM


  • Hi

    create a separate list,

    linked to main list , based on trip_ID , and in this new list, add column for your needed values

    Calculate these values using a workflow attached to main list

    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    • Marked as answer by Victoria Xia Tuesday, March 17, 2015 1:55 PM
    Monday, March 9, 2015 1:49 PM