Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to calculate the addition of several entries in the same cell? (Margin calcul)

Topic Labels: Formulas
Solved
Jump to Solution
259 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello !

I am trying to calculate my margins on my projects.

All my costs appear in the “Costs” box.

I would like to add up all these costs in the next cell “total costs”.

Which dormule should I write?

Then what formula should I write to subtract “TTC cell” - “Total Cost”?

Thank you very much for your help, very much appreciated :slightly_smiling_face:

Capture d’écran 2021-05-13 à 22.59.29

1 Solution

Accepted Solutions
  1. Turn {Total Costs} into a Rollup-type field that uses the aggregation SUM(values)
  2. Turn {Margin} into a Formula-type field that uses the formula {Total Costs} - {TTC}

See Solution in Thread

2 Replies 2
  1. Turn {Total Costs} into a Rollup-type field that uses the aggregation SUM(values)
  2. Turn {Margin} into a Formula-type field that uses the formula {Total Costs} - {TTC}

Thanks Kamille_parks !! :clap:t2: