Forum Discussion

TimLivermon's avatar
TimLivermon
Qrew Member
6 years ago

Summing Costs from Multiple Rows and Columns

May I ask for advice on creating a formula to add costs from two columns and multiple rows?

I'm importing a report and calculating the two Cost columns. I need to add the Model Material Cost and Support Material Cost to get the Total Cost for Job. The image below shows report. I'm not sure which function would work to do that for each job. This is my first QB app. Thank you.



App builders
Formulas and functions
reports and charts
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    6 years ago
    no problem,

    You can make a new field called 

    Total Cost 

    as a formula numeric field.

     The formula would be

    [Model Material Cost] + [Support Material Cost]
  • TimLivermon's avatar
    TimLivermon
    Qrew Member
    6 years ago
    Thank you for the quick response. I tried to paste an image of the report showing the report fields I need to add with the original question but it didn't show up. I'll try to paste again below. The material types have different costs so I can't use the total which is 1992 for the first job. That comes the the program that generates the imported file. The Total Cost formula would add the 3 Model Material Costs to to the Support Material Cost for the first Job and then go to the next Job. 



    Thanks again.