How to get Percentage value

[Supriya25]

Hi,

Through Business rule i am getting right Percentage , but client wants onChange

Total Revenue of Project ( $ ) - field Integer type

Project Profitability ( $ ) - field Integer type

Formula : (U-R)/U

var projectrevenue = g_form.getValue('u_total_revenue_per_milestone'); //U//
var projectcost = g_form.getValue('u_project_profitability'); //R//
var percentage=(projectrevenue -projectcost )/projectrevenue 
 var percentagevalue = percentage * 100;
 alert('percentage :'+percentagevalue);
 g_form.setValue('u_gpm', percentagevalue.toFixed(2));

[Supriya25]

Hi Mike,

[Mike Patel]

Oh yes, Totally forgot that it can be only used in server side script.

so try

var projectrevenue = g_form.getValue('u_total_revenue_per_milestone'); //U//
var projectcost = g_form.getValue('u_project_profitability'); //R//
var pr = parseInt(projectrevenue);
var pc =parseInt(projectcost);
alert(pr + "---" + pc);

var percentage = pr - pc;

alert(percentage);
var uu = percentage / pr;
alert(uu);
var percentagevalue = parseFloat(percentage * 100);
alert('percentage :' + percentagevalue);
g_form.setValue('u_gpm', percentagevalue.toFixed(2));

[mihirr]

Hello,

A solution for this, when we want to use an integer field for a calculation we don't need the comma's.

So add the attribute "format=none" to the dictionary entry of the respective integer fields. This will drop the comma allowing the calculation to work.

Let me know if it worked.

Regards,

Mihir Rathod.

[mihirr]

My trial screenshot,