Solved

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

  • 28 March 2024
  • 3 replies
  • 32 views
D
Rank
Userlevel 3
Badge

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'

icon

Best answer by Laura02 29 March 2024, 02:12

View original

3 replies

M
Rank
Userlevel 4
Badge

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
Rank
Badge +18

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

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
D
Rank
Userlevel 3
Badge

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

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved