Forum Discussion

kristel_tulio's avatar
kristel_tulio
Helper III
3 years ago
Solved

Divide by zero error

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.

 

 

  • amitchandak's avatar
    amitchandak
    3 years ago

    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