Solved

Show 0's in ARM report rows instead of blanks

  • 28 December 2023
  • 5 replies
  • 49 views

Userlevel 4
Badge +1

In ARM report, if the data source for a row has no activity, the row shows blank. I need it to show ‘0’

 

I tried the IsNull formula. This works if I have no accounts in the data source, but if I have accounts selected with no activity in the period, it still shows blank. So it’s looking at the data source rather than the result/activity. Anyone know how this might be accomplished?

Thank you

 

 

icon

Best answer by Robert Sternberg 28 December 2023, 23:32

View original

5 replies

Userlevel 4
Badge +1

To clarify, row 0120 shows ‘0’ in the result because I have no account in data source. 0125 is still blank because I have account 40000 selected. Need 0125 to show ‘0’

Badge +18

Hello @jhouser ,

Hide Zero setting in Row and/or Column controls whether you see null or ‘0’. Have you already checked this setting?

Laura

Userlevel 7
Badge +8

Another option would be to set your format to #.##0.00 which will show a zero or a number.  This is typically placed in your column set rather than your row set for better control. 

 

Why #.##0.00?

  • # placeholders are used for optional digits. They display a digit if it is present, but do not display extra zeros if the digit is not there.
  • 0 placeholders ensure that a digit is always displayed, even if it's a zero. This is useful for ensuring consistent decimal places.
Userlevel 4
Badge +1

@Laura02 My understanding/experience is that Hide Zero checkbox will hide row if the result is 0. That’s not what we’re looking for. We want empty results (no activity for period, so blank result) to show a ‘0’. But please correct me if I’m wrong. :) 

Userlevel 4
Badge +1

@Robert Sternberg Thanks for your help!

Reply


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