I am using TDP version 126.96.36.1994 64 bit
I am trying to build a statement based on certain criteria - one being a Calculated field. It appears it does not recognize the fields alias and wants to input the code behind it instead. Is there a way to reference the result in the field and not the code behind the result?
In the case below "CheckComplete" is the Computed field. CheckComplete tells me if there is enough inventory on hand to fulfill that line request and returns a 'YES'. If not, it is Null. I am trying to see if there are the same amount of records for a particular Unique field (SO_ID) below and CheckComplete. I am also assuming that Count(distinct CheckComplete) will not return nulls.
WHEN SO_HDR.SO_NOTES_NT LIKE '%ASAP%' AND INVT.ON_HAND_QTY <0
OR SO_HDR.SO_NOTES_NT LIKE '%RED%' AND INVT.ON_HAND_QTY <0
OR SO_HDR.SO_NOTES_NT LIKE '%COMPLETE%' AND
COUNT(DISTINCT "SO_ID" )=COUNT(DISTINCT "CHECKCOMPLETE")