I'm using CR 10. I have a formula that keeps giving me the following error:
"The remaining text does not appear to be part of the formula"
The error occurs beginning and ending with the highlighted code.
Here is my code:
What exactly am I missing here....a colon, semi-colon after each statement?Code:if {tblBatchDetail.carrierSCAC} > "" then if {tblBatchDetail.fein} > "" then {tblBatchDetail.carrierSCAC} & "/" & {tblBatchDetail.fein}; if {tblCarriers.AdventCarrierCD} > "" then {tblBatchDetail.carrierSCAC} & "/" & {tblBatchDetail.fein} & "/" & {tblCarriers.AdventCarrierCD} else {tblBatchDetail.carrierSCAC} & "/" & {tblBatchDetail.fein} & "/(Unk)" else {tblBatchDetail.carrierSCAC} & "/(Unk)" else "Unkown" end if




Reply With Quote