Skip to main content
Solved

ARM Report


I created a Row & Column Set for a custom report.  I need a % of Salaries & % of Revenue to show in each column.  Below is the result.  T&B % should calculate off Salaries & % of Revenue calculates from Total Payroll Expense.   

 

Best answer by Laura02

Hi,

What is the formatting on your columns?  Are they rounding?  It seems like smaller numbers become 0 and larger numbers become 100; nothing in between.

Next, please try removing formatting from columns, maybe from rows to allow all figures to print, even if un-rounded.  After that, experiment to get the proper formatting, number of decimal characters, % etc.

If that doesn’t work, I would like to try renumbering Row Codes with at least 4 digits, just to rule out.  I think it’s unique to have 3-digit row numbers in a Row Set. (Use the Renumber function at the top of the Row Set.)

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

9 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • March 8, 2023

Good morning,

What is the numerator and denominator in your equation? For example:

“% of Revenue calculates from Total Payroll Expense”

I understand in this case , Total Payroll Expense is your denominator. What row is the numerator?

For example, I am showing Other Expenses as a percent of Total Operating Expenses in the last row of this example:

 


  • Author
  • Freshman I
  • 8 replies
  • March 8, 2023

Below are my settings...The rows with red arrows are not appearing on the report.

 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • March 8, 2023

Hello,

It may be useful to see all the columns with labels - I can’t tell what might be marked Hidden in the above shot.

There is another option, Cell Evaluation Order in the Column configuration to calculate rows first or columns first. It may help you to reverse this setting from the default:

 


  • Author
  • Freshman I
  • 8 replies
  • March 8, 2023

I tried the Cell Evaluation Order Error received “You cannot use Cell Evaluation Order set to Column for columns of the GL Type”.   Below is a screen shot of the Row Set Settings:

 


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

Hi,

What is the formatting on your columns?  Are they rounding?  It seems like smaller numbers become 0 and larger numbers become 100; nothing in between.

Next, please try removing formatting from columns, maybe from rows to allow all figures to print, even if un-rounded.  After that, experiment to get the proper formatting, number of decimal characters, % etc.

If that doesn’t work, I would like to try renumbering Row Codes with at least 4 digits, just to rule out.  I think it’s unique to have 3-digit row numbers in a Row Set. (Use the Renumber function at the top of the Row Set.)


  • Author
  • Freshman I
  • 8 replies
  • March 8, 2023

😁 Wow, just that little setting of switching to No Rounding, fixed the issue.   All good.   Thank you and really helpful to reach out and talk through it with someone.    Thank you again. 


  • Author
  • Freshman I
  • 8 replies
  • March 8, 2023

Laura, would like to open this topic again.  This first column is not totaling properly:

Any recommendations?  


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • March 8, 2023

Hello @lwiemann17 ,

It’s hard for me to see, but it appears the highlighted total is correct in the Admin column. We are only adding Field Reg Salaries with Tax & Benefits, yes?

 


  • Author
  • Freshman I
  • 8 replies
  • March 8, 2023

Please disregard.  I have been up too long.   Thank you.


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