Incompatibility the ClearError() with the Join()

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Solved2.78K viewsFormulas and Functions

Hi all,

FYI. [b:3ogmvrrq]ClearError()[/b:3ogmvrrq] can not catch an [u:3ogmvrrq]error-value[/u:3ogmvrrq] from [b:3ogmvrrq]Join()[/b:3ogmvrrq] and can not display [u:3ogmvrrq]replacement-value[/u:3ogmvrrq].

For details, see the model file. The model is rather simple and self-explanatory. You need to enter the Start and End. If Start will be greater then End, then QM should display Alert 3 times in the Report items group. This is exactly what QM does, except the item SubSales.

I wonder whether will be any response from the QM-team or not?

See the model file: [b:3ogmvrrq]QM5.3.7 Incompatibility the ClearError() with the Join(). SAU[/b:3ogmvrrq]

Selected answer as best

[quote:1iq9fiy0]Join then cannot operate on a #value error so it then returns another #value error:[/quote:1iq9fiy0]

Apologies this should say: [b:1iq9fiy0]Join operates on the #value as a string and returns the[i:1iq9fiy0] string[/i:1iq9fiy0] #value.[/b:1iq9fiy0]


You are viewing 1 out of 5 answers, click here to view all answers.