Skip to main content

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.

 

 

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

 


Ta da, thank you so much!!


Reply