I am trying to divide the results from Column B by a value in a Row. I have tried various combinations of the following. Can someone please suggest? If you are wondering, I am using the @BaseRowCode for another column. Thanks!
B/@RowCode = 0280
=B/ Value(@RowCode ,0280)
=B/ Value(@RowCode ,'0280’)
=B/ Value(@RowCode ,'B') = '0280'
Best answer by Laura03
Hello,
We can also use Column divided by Column-Row like this formula: B/B0180
Suppose I want to add % of sales to the report shown below, using the circled YTD 2022 Total Revenue figure as the basis:
Laura
If it should divide from a particular row and column, the expression should be =B/ Value( row, column)
For example if B needs to be divided by the value of column C row 0800 then the formular would be:
=B/Value(‘0800’,’C’)
+19Hello,
We can also use Column divided by Column-Row like this formula: B/B0180
Suppose I want to add % of sales to the report shown below, using the circled YTD 2022 Total Revenue figure as the basis:
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
