Skip to main content

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.

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

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


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$

Reply


Terms & Conditions