Coda Formulas - How to multiply items in the same column?

I’m new to coda, i’m trying to understand basic stuff that I can do with sheets or excel, but something so simple in some programs looks IMPOSSIBLE to me after hours of trying. I just give up

Anyone can tell me what am I doing wrong? I don’t think i’m asking for something so over complicated.

I only want to multiply (product.1 * product.2 ) / 1000

Welcome to Coda!
Doing row-specific calculations isn’t ideal in Coda. It makes more sense to transpose your table in this case. Calculations are usually defined for entire columns!

image

Calculation formula for the “what i want” column:

thisRow.Number * thisRow.[Number 2] / 1000
1 Like

Welcome @Vince_Collado

Another option: if you need to get this type o % in a column and you do not find it in Summary, you can write a formula outside the table to summary. See an example in the image below:

1 Like

Hey guys, thanks for both answers. I ended up changing rows for columns and it worked flawlessly. I felt so helpless when trying the original input.

Thanks again,

Enjoy a great week.

2 Likes