Incompatibility the ClearError() with the Join()

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Solved2.11K viewsFormulas and Functions
0

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
0

[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]

James

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

Latest Questions