Hi I have this
IF {CUST.COUNTRY}='' then 'U.S.A.' else{COUNTRY.NAME}
I am using that so that all us states come under one heading but I also need to compare the customers state with the address state and if the customer state does not equal the address state to make it the address state else customer state. I thought if I added this to the above it would do what I want:
and IF {CUST.STATE}<> {ADDRESS.STATE} then {ADDRESS.STATE} else {CUST.STATE}
but it tells me it wants a boolan, is there a way to get thsi to work? Thanks
IF {CUST.COUNTRY}='' then 'U.S.A.' else{COUNTRY.NAME}
I am using that so that all us states come under one heading but I also need to compare the customers state with the address state and if the customer state does not equal the address state to make it the address state else customer state. I thought if I added this to the above it would do what I want:
and IF {CUST.STATE}<> {ADDRESS.STATE} then {ADDRESS.STATE} else {CUST.STATE}
but it tells me it wants a boolan, is there a way to get thsi to work? Thanks