Skip to main content

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. 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:

Terms & ConditionsAccessibility statement