Skip to main content
Solved

Help with Null Formula for Style in GI


Forum|alt.badge.img

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
Did this topic help you find an answer to your question?

2 replies

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

 


Forum|alt.badge.img
  • Author
  • Freshman I
  • 14 replies
  • October 10, 2024

Ta da, thank you so much!!


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