This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have below table. I want '0' to be replaced with the above value whichever it is. For example Column 'A' has -169, I want to replace to the below column where we have '0' and for -1697 to be replaced to below column where we have '0'. and also divided by two for the new column which is a1 c1.
But i just want to confirm, Do we not have any formula which we can simply apply without using sort, multi formula or record ID. for Example if we have "0' so please use value from upper column till we have a value and same to next "0" if found below:
Formula tool works only on row-level (i,e it only looks to its specific row for calculation). If we want to use calculation which is dependent on upper/lower row then we need multi-row formula tool. And since you want to use this formula for multiple columns and multi-row formula tool can output only one column at a time. So @Qiu is using record id, tranpose, sort method to apply multi-row formula for multiple column in at a single tool.
So these steps are needed and this would be the way to go to solve this usecase.