Forum Discussion
iserror 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 ...
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.
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?
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?
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 🙂