Skip to main content
Solved

ARM Report: Column Formula using a specific row in that formula


Forum|alt.badge.img

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 Laura02

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:

 

Total Revenue 2022 resides in cell B0180
Try highlighted formula

Laura

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img

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’)

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • March 29, 2024

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:

 

Total Revenue 2022 resides in cell B0180
Try highlighted formula

Laura


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 39 replies
  • March 29, 2024

Both are EXTREMELY helpful!!  Thank you so much!!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings