BAQ Calcuated Field with If condition

Yahoo Archive
1
"" will work for a blank field.   There is always the possibility that is it not "blank" but null, Null and Blank are not the same thing, in that case you can use the ? to test for null.  To bypass the need to test for blank and null I frequently use the length() function.

(If length(somefield) > 0 then ValuewhenFieldHasaValue else ValuewhenFieldisBlank)

Jim Kinneman
Encompass Solutions, Inc
2

Within the BAQ design, I'm creating an If condition calculated field, and I don't know what Epicor recognizes as a "blank" field.

In Excel, If formulas use the double quotations "" to represent blank.  Does anyone know what keystrokes I use in Epicor for a blank field?

3

On numeric fields, 0 = blank

 

On character fields, '' = blank    (single quotes)

 

You can also use       IS NULL and IS NOT NULL   like:

 

WHERE OrderHed.ShipDate IS NULL

 

 

This will help you too:Â http://knowledgebase.progress.com/articles/Article/P98288

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 07, 2014 2:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ Calcuated Field with If condition

 

 

Within the BAQ design, I'm creating an If condition calculated field, and I don't know what Epicor recognizes as a "blank" field.

In Excel, If formulas use the double quotations "" to represent blank.  Does anyone know what keystrokes I use in Epicor for a blank field?