This content has been marked as final. Show 4 replies
There's a field called 'Omschrijving' and when this field contains "accrual" the Field TYPE_2 will be discounts_accrual and otherwise discounts.
I used the below logic that seems to work but gives me duplicate lines when the logic is true.
if(Len(SubField(Lower(Omschrijving),'accrual'))<Len(Omschrijving),'Discounts_accrual','Discounts') as TYPE_2.
Can anyone tell me why this is happening and wether there's a better way then using subfield?