Skip to main content
Answer

Help with Null Formula for Style in GI

  • October 10, 2024
  • 2 replies
  • 27 views
T
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)

 

TamiLynn

    2 replies

    darylbowman
    Captain II
    Forum|alt.badge.img+15
    • darylbowman
    • Answer
    • October 10, 2024
    =IIf([SOOrder.CustomerRefNbr]<>'' And [SOOrder.CustomerRefNbr]<>Null, 'blue40', default)

     

    Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
    Chris Hackett
    T
    Jr Varsity III
    • thoyt76
    • Author
    • October 10, 2024

    Ta da, thank you so much!!

    TamiLynn
    darylbowman
    Chris Hackett
    Terms & ConditionsCookie settingsAccessibility 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