Hello,
I have two data extracts which have been joined and ingested into my app. I have two sheets, one for if policy numbers match and give an extract of both data tables into one showing matching policies, and give another extract which shows policy numbers which do not match.
I have the first expression built which works and is fine, however trying the does not match does not seem to work? Any suggestions,
=if(dpoPolicyNumber=PolicyNumberExcel, dpoPolicyNumber) - This expression is used to look at both fields and if both match, then given an output of the matching Policy Numbers.
I tried
=if(dpoPolicyNumber -= PolicyNumberExcel, dpoPolicyNumber) - -= as does not equal but this errors? any help would be appreciated,
thanks
