Trying to find a way to handle the Calc Failed error message when TagName() cannot find a tag for an attribute.
I have 2 AF attributes, FIT_YEST_CA and FIT_YEST. We also have mixer of tag names with suffix either FIT_YEST_CA or FIT_YEST.
With TagName() function I can find out which tag is exists - however, when I use any IF condition to determine what action I want to take then I get Calc Failed error since one of them does not exist.
I was trying the following code:
if Len(TagName('FIT_YEST')) > 0 then "|FIT_YEST"
else if Len(TagName('FIT_YEST_CA')) > 0 then "|FIT_YEST_CA"
I was wondering, if anyone knows a best way to handle this error like in MS Excel we have IFERROR()
Any help will be highly appreciated.