Skip to main content
Solved

Help with Null Formula for Style in GI

  • Oct 10, 2024 6:53 PM UTC
  • 2 replies
  • 64 views
  • Translate All
Jr Varsity III

Hello,

Can someone please help me with a null formula in my GI. If my customer reference number field is NOT blank, I would like it to have Blue or Blue Font. Here is what I came up with:

 

=IIf( [SOOrder.CustomerRefNbr] <>' ' , 'blue40', default)

 

The result is everything is blue.

 

 

Best answer by darylbowman

=IIf([SOOrder.CustomerRefNbr]<>'' And [SOOrder.CustomerRefNbr]<>Null, 'blue40', default)

 

View original
TamiLynn

    2 replies

    darylbowman
    Captain II
    Forum|alt.badge.img+17
    =IIf([SOOrder.CustomerRefNbr]<>'' And [SOOrder.CustomerRefNbr]<>Null, 'blue40', default)

     

    Translate
    Daryl 🧩 I build Acumatica add-ons 🔗deftstrokesdev.com/products?ref=forum_sig
      Jr Varsity III
      • thoyt76
      • Author
      • Oct 10, 2024 7:09 PM UTC

      Ta da, thank you so much!!

      Translate
      TamiLynn
        Terms & ConditionsAccessibility statement
        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