Divide by zero error

[kristel_tulio]

Hi, asking for your help how to fix this. I'm getting an error "Divide by zero encountered" when loading my data. This is the calculations I think that causing the error. The calculated column is working but my whole dataset is not loading properly. Thank you

z Payments Calculated Amount = SWITCH( TRUE(),
[Line Amount Types] = "Inclusive" && [Type] = "ACCREC",
(([Line Amount]-[Tax Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "Exclusive" && [Type] = "ACCREC",
(([Line Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "NoTax" && [Type] = "ACCREC",
(([Line Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "Inclusive" && [Type] = "ACCPAY",
(0-([Line Amount]-[Tax Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "NoTax" || [Line Amount Types] = "NoTax" && [Type] = "ACCPAY",
((0-[Line Amount]) * ( [PaymentAmount] / [Invoice Total] )),
[Line Amount Types] = "Exclusive" || [Line Amount Types] = "NoTax" && [Type] = "ACCPAY",
((0-[Line Amount]) * ( [PaymentAmount] / [Invoice Total] )),
0)

I tried using the DIVIDE() function but still getting the same error.

[kristel_tulio]

Thanks @amitchandak, will check those

[amitchandak · Accepted solution]

@kristel_tulio , Remove this column and check, this may be because of something else. In case you are using query in Power bi or View at source, check those too