Solved

GI Color formatting

  • 2 February 2024
  • 3 replies
  • 68 views

Userlevel 3
Badge

I’m looking to figure out how to make my row styles based on the Days Lagging column, which is a formula that is the following:

=DateDiff('d', [SOOrder.OrderDate], Today())

 

I’d like to color code on the Days Lagging to show Red as greater than 90 days, yellow greater than 60 days, green greater than 30 days.  I’ve tried using a Switch statement that has IIf inside to do the same math, but I’m getting out of bound array issues.

 

What am I doing wrong lol?

icon

Best answer by kyle90 2 February 2024, 20:50

View original

3 replies

Userlevel 2
Badge

Hi, can you share your Switch statement that didn’t work for you?

Userlevel 4
Badge +1

I’m not an expert here but I believe =switch() won’t need an if statement, it applies the the logic in order and does nothing if your expression is not true

 

Try

=switch(

DateDiff('d', [SOOrder.OrderDate], Today())>’90’,’red20’,

DateDiff('d', [SOOrder.OrderDate], Today())>’60’,’yellow20’,

DateDiff('d', [SOOrder.OrderDate], Today())>’30’,’green20’

)

Userlevel 3
Badge

yeah, I see the issue.  Don't know why my brain wanted to force the If there.

 

Thanks

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