Receiving NaN error, When numbers or divided (other than zero) and even Zero divided by number get same Error

[farci]

Hi All,

I am receiving NaN error when two numbers are getting divided and even Zero divided by number gets me Nan Error. Below are the screenshot of error and the scripts.

I am trying to divide numerator with denominator and arriving at the result.

Here is the code

// SERVICE REQUEST

if(current.backup_type=="Service Request"){

var cal = new GlideAggregate('x_pm_service_request_backup_template');

ret = cal.addQuery('pri',current.priority_one);

ret.addOrCondition('pri',current.priority_two);

cal.addQuery('service_provider_name',current.sp_name);

cal.addQuery('si_sec',"Met");

cal.addQuery('service_month',current.serv_mon);

cal.addAggregate('COUNT');

cal.query();

var numerator = 0;

if(cal.next())

numerator = cal.getAggregate('COUNT');

//SERVICE REQUEST EXCEPTION

var exp = new GlideAggregate('x_pm_service_request_backup_template');

var pri = cal.addQuery('pri',current.priority_one);

pri.addOrCondition('pri',current.priority_two);

var ret= exp.addQuery('exp_status',"Approved");

ret.addCondition('si_sec',"Not Met");

exp.addQuery('service_provider_name',current.sp_name);

exp.addQuery('service_month',current.serv_mon);

exp.addAggregate('COUNT');

exp.query();

var exception = 0;

if(exp.next())

exception = exp.getAggregate('COUNT');

var res1= (parseInt(numerator) + parseInt(exception));

current.si_num = res1.toFixed(0);

var cal1 = new GlideAggregate('x_pm_service_request_backup_template');

//cal1.addQuery('pri',current.priority_one);

var ret = cal1.addQuery('pri',current.priority_one);

ret.addOrCondition('pri',current.priority_two);

cal1.addQuery('service_provider_name',current.sp_name);

var addups = cal1.addQuery('si_sec',"Not Met");

addups.addOrCondition('si_sec',"Met");

cal1.addQuery('service_month',current.serv_mon);

cal1.addAggregate('COUNT');

cal1.query();

var denominator = 0;

if(cal1.next())

denominator = cal1.getAggregate('COUNT');

current.si_deno = denominator;

var res = (res / denominator) * 100;

current.si_vr = res.toFixed(2);

current.update();

action.setRedirectURL(current);

}

Appreciate your quick response

Regards,

Narmi

[Chandu Telu · Accepted solution]

you can use the below code to convert

var a =   g_form.getValue("short_description");

var b =   g_form.getValue("description");

var c = (+a) /(+b);

alert("hello"+c);

[farci]

Hi Chandu,

Thank You for your inputs, The same old formula worked for me, I just had to modify the variable (from res to res1) when it was doing the final division.

Its a server side script in UI action. Any suggestion on how I can improvise this script?

Regards,

Narmi