Dec 31, 2019 05:01 AM
Hi there,
I have 4 columns in a table:
1.duration (number, manual) -> 2 hour
2. fixed price (number, manual) -> 30$
3. sum of this row (formula) -> 60$
4. paid price (number, manual) 45$
How can I calculate the SUM for the 3 and 4 columns?
Thank you.
Jan 01, 2020 02:48 PM
Hi @Chen_Pro - you can just add the fields:
{Field 1} + {Field 2}
In my example the formula is:
{Cost (Duration * Rate)} + {Paid Price}
JB
Jan 02, 2020 12:35 AM
Hi, Thank you for your reply,
This way I get only the SUM of the ROW.
What can I do to get the SUM of the whole 2 columns?
(In case that I want to calculate how much debt remains)
Hours | Fixed Price | Sum | Paid | Debt |
---|---|---|---|---|
2 | 30$ | 60$ | 45$ | 25$ |
3 | 25$ | 75$ | 60$ | 40$ |
1 | 30$ | 30$ | 40$ | 30$ |