This content has been marked as final. Show 2 replies
You can check for the length of that field in the script, and set its value to 0, so when it's aggregated or summed in the script will return 0.
LOAD ... If(Len(InvoiceValue) > 9, 0, InvoiceValue) AS InvoiceValue, If(Len(InvoiceValue) > 9, 1) AS FlagIncorrectInvoiceValue, ...
Hope that helps.