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.68K 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

Hi James,

Thank you for your response. The formula is really working. However, the expression of the functions: ClearError(Join(ClearError(…))), – is not obvious.

Maybe you will make the minimum explanations once.

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