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

[jefferson_lello]

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:

[Kamille_Parks · Accepted solution]

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}

[jefferson_lello]

Thanks Kamille_parks !! :clap:t2: