Help

SUM for 2 columns

3119 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Chen_Pro
6 - Interface Innovator
6 - Interface Innovator

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.

2 Replies 2

Hi @Chen_Pro - you can just add the fields:

{Field 1} + {Field 2}

Screenshot 2020-01-01 at 22.47.07

In my example the formula is:

{Cost (Duration * Rate)} + {Paid Price}

JB

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$