Calculated fields

I am trying to divide Row 0, value 0 over Row5, value 4… and another calculation of (Row 0, value 0) over (Row5, value 4 - row2,value 2. ) i tried many ways …math formula, column lag… i don’t know what i am missing… can you please advise ?

image

Row 0, value 0 over Row5, value 2… and another calculation of (Row 0, value 0) over (Row5, value 2 - row2,value 1. )

It’s still unclear to me what you’re trying to do. I don’t really understand your description of rows and values.

What is your expected result?

I am trying to calculate by cell number 450xxxx /146xxxxxx
the second formula is 450xxxx / (146xxxxx- 343xxxxx)

i need these two values as an output

hi @Toronto825 ,
maybe a solution could be a workflow like this
- “Columns Filter” → keep only the “Value” column
immagine

- “Transpose Table”
immagine
- “Column Expressions”

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.