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 ?
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
- “Transpose Table”
- “Column Expressions”
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.