I struggle with this all the time and I’m hoping someone can help me out and then I will document it so that I never forget again.
I have two scenarios and maybe the solution is the same for both.
- I want to create a calculated field in the BAQ where if a date field is empty (e.g. Customer.EstDate) then output some date that I define.
- I have an outer join between two tables (e.g. Vendor -> POHeader). If there are no associated POs then output a value I’ve supplied.
In scenario 1, I’ve tried the following with not success:
if Customer.EstDate = ?.. (this throw a syntax error)
if Customer.EstDate = “” …(this compiles fine but does not “work”)
In the end, I found the idea of comparing to an unused user defined field and this works but I feel like there is another way.
In scenario 2, I’ve tried the same two above and also:
if IsNull(POHeader.OrderDate) … (this compiled but did not work)