Help

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

Solved
Jump to Solution
448 1
cancel
Showing results for 
Search instead for 
Did you mean: 
jefferson_lello
4 - Data Explorer
4 - Data Explorer

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
Kamille_Parks
16 - Uranus
16 - Uranus
  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
Kamille_Parks
16 - Uranus
16 - Uranus
  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: