iserror is false, but does return an error

[DouweMeer]

Entity =

VAR a1 = find ( " -" , [Classification] )

VAR a2 = len ( [Classification] )

VAR a3 = trim( right ( [Classification] , a2 - a1 -1 ) )

VAR a4 = find ( " -" , a3 )

VAR a6 = trim ( left ( a3 , a4 -1 ) )

RETURN

if ( iserror ( a6 ) , "True" , a6 )

The search Text provided to function 'FIND' could not be found in the given text.

However...

if ( iserror ( a6) , "True" , "False" ) = "False"

I don't understand how this can even give an error. Am I missing something?

[ChrisMendoza]

@DouweMeer -

My guess is you should declare the 4th argument of FIND ( ) as BLANK ( ). Something like:

= FIND ( " -", 'Table'[Column1], ,BLANK ( ) )

[DouweMeer]

Hey @ChrisMendoza 

I wasn't so much looking for a workaround, more a like an understanding of why the iserror appears to fail. As for the solution, I created myself the following : 

Entity =

VAR a1 = find ( " -" , [Classification] )

VAR a2 = len ( [Classification] )

VAR a3 = trim( right ( [Classification] , a2 - a1 -1 ) )

VAR a4 = if ( iserror ( find ( " -" , a3 ) ) , BLANK() , find ( " -" , a3 ) )

VAR a6 = if ( a4 = BLANK() , BLANK() , trim ( left ( a3 , a4 -1 ) ) )

RETURN

if ( iserror ( a6 ) , 'AC'[Wholesaler Name] , a6 )

As a test I changed my original to your suggestion: 

Entity =

VAR a1 = find ( " -" , [Classification] )

VAR a2 = len ( [Classification] )

VAR a3 = trim( right ( [Classification] , a2 - a1 -1 ) )

VAR a4 = FIND ( " -", a3 ,BLANK ( ) )

VAR a6 = if ( a4 = BLANK() , BLANK() , trim ( left ( a3 , a4 -1 ) ) )

RETURN

if ( iserror ( a6 ) , "True" , a6 )

This returns the following error :

An argument of function 'FIND' has the wrong data type or has an invalid value.

I wouldn't mind to validate another attempt if you want to give it another shot via your method.  

[ChrisMendoza]

---

@DouweMeer wrote:

Hey @ChrisMendoza 

...

As a test I changed my original to your suggestion: 

Entity =

VAR a1 = find ( " -" , [Classification] )

VAR a2 = len ( [Classification] )

VAR a3 = trim( right ( [Classification] , a2 - a1 -1 ) )

VAR a4 = FIND ( " -", a3 ,BLANK ( ) )

VAR a6 = if ( a4 = BLANK() , BLANK() , trim ( left ( a3 , a4 -1 ) ) )

RETURN

if ( iserror ( a6 ) , "True" , a6 )

This returns the following error :

An argument of function 'FIND' has the wrong data type or has an invalid value.

I wouldn't mind to validate another attempt if you want to give it another shot via your method.  

---

You missed the comma in

VAR a4 = FIND ( " -", a3 ,BLANK ( ) )

Should be 

VAR a4 = FIND ( " -", a3, ,BLANK ( ) )

Can you provide a sample of your data?

[DouweMeer]

@ChrisMendoza 

Felt a bit like:

Your suggestion was able to replace the if iserror boolean. Afterwards I read to documentation. Learned something new today :).

Do you, by any chance, know why my first solution didn't worked?

[ChrisMendoza]

@DouweMeer -

I do not know the reason for the failure. In a sample I created I did not receive a failure. That is the reason I asked for a sample from you 🙂