Forum Discussion
DouweMeer
Impactful Individual
Impactful Individualiserror is false, but does return an error
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 ...
DouweMeerImpactful Individual
Impactful IndividualHey 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
Resident Rockstar
Resident Rockstar
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 ) ) )RETURNif ( 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
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
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 🙂