How to fix "Error in formula or condition: float division by zero"

Raymond_Liew · September 27, 2019, 4:38am

Hi all, I was scripting (client-side) to calculate the amount to deduct for Leave without Pay in Salary Slip. I couldn’t use the default calculation method in ERPNext. This is because under the labor law of my country:

Salary below $1500: the deduction for Leave without Pay has to be based on the number of days in the month. e.g. 28 days during Feb.
Salary above $1500: the deduction for Leave without Pay will be based on the company’s policy i.e. 22 days

So the calculation should for Feb 2019 (28 days)

Employee Zack: Took 2 days of Leave without Pay
Basic (earning): $1500
Leave without Pay (deduction): $1500 / 28 * 2 = $107.14
Net Salary: $1500 - $107.14 = $1392.86
Employee Cindy: Took 2 days of Leave without Pay
Basic (earning): $3000
Leave without Pay (deduction): $3000 / 22 * 2 = $272.72
Net Salary: $3000 - $272.72 = $2727.28

But during the creation of salary slip, I received an error: “Error in formula or condition: float division by zero”

This is the formula I put for Leave without Pay salary component (Note that ‘total_days_in_the_month’ is a custom field I inserted in Salary Slip doctype):

(basic / total_days_in_the_month * leave_without_pay) if basic < 1500 else (basic / 22 * leave_without_pay)

This is the custom script (client-side) for Salary Slip.

frappe.ui.form.on('Salary Slip', "refresh", function(frm, cdt, cdn){
        var d = locals[cdt][cdn];
        frappe.model.set_value(cdt, cdn, 'total_days_in_the_month', frappe.datetime.get_day_diff( d.end_date , d.start_date));
        refresh_field('total_days_in_the_month');
    });

Raymond_Liew · September 27, 2019, 4:42am

Actually, this script here isn’t correct either because it calculated 27 days ( 28 Feb - 1 Feb = 27 days difference). I wanted to include start date in calculation (1 day is added)… I would really appreciate if there’s anyone that can guide me on this part as well. Thank you in advance.

Raymond_Liew · September 30, 2019, 1:32am

Anyone?

arokia · September 30, 2019, 4:21am

Can you explain breifly how you want to calculate with examples?

Raymond_Liew · September 30, 2019, 6:41am

Hi @arokia,

This is the screenshot of Salary Slip doctype:

This is the preview of Salary Slip:

Problem 1: As mentioned earlier, this is the custom script I used to calculate the total no of days in the month:

Problem 2: This is the formula in Leave without Pay salary component:

This is the error message:

I suspect the cause of this error message is that despite the fact I have inserted “Total Days in the Month” as float in the DocType, the actual data (XX days) is a string data. Therefore, the formula in the Leave without Pay salary component was unable to calculate.