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
May 13, 2021 02:10 PM
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:
Solved! Go to Solution.
May 13, 2021 02:51 PM
{Total Costs}
into a Rollup
-type field that uses the aggregation SUM(values)
{Margin}
into a Formula
-type field that uses the formula {Total Costs} - {TTC}
May 13, 2021 02:51 PM
{Total Costs}
into a Rollup
-type field that uses the aggregation SUM(values)
{Margin}
into a Formula
-type field that uses the formula {Total Costs} - {TTC}
May 13, 2021 03:42 PM
Thanks Kamille_parks !! :clap:t2: