Transformations: Enhancement for fivetran salesforce formula
PlannedTeam,
In many cases our formulas are being parsed as `something / COALESCE(#,0)`. This frequently results in a DIV by Zero error.
One small improvement that may go a long way will be to add NULLIF clauses to the denominator e.g. `something / NULLIF(COALESCE(#,0),0)`
Thanks,
KG
-
Official comment
Hi Kevin,
Thanks for reporting this. We'd love to take a look at the specifics and get this fixed. Could you share the details of the formula with our support team via a support ticket? From there we can escalate to engineering to get specific erroneous translations fixed.
Please sign in to leave a comment.
Comments
1 comment