Another possible "hack" is to convert the credit score to a boolean (null converts to false) and multiply it with the original UPB, which will implicitly cast the boolean to a number (false = 0, true = 1). If there's no credit score, the original UPB will be multiplied by 0, which will zero it out. Otherwise it will be multiplied by 1, which will not change its value.
ficoUPB = SUM( TO_BOOL( l.Acquisition.BORROWER_CREDIT_SCORE ) * l. Acquisition.ORIGINAL_UPB ) -- You received this message because you are subscribed to the Google Groups "ArangoDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
