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

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:

  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}
1 Like

Thanks Kamille_parks !! :clap:t2:

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.