How to get Percentage value

Supriya25
Tera Guru

Hi,

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

find_real_file.png

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));

1 ACCEPTED SOLUTION

Try below.

var projectrevenue = g_form.getValue('u_total_revenue_per_milestone').replace(/,/g,'')); //U//
var projectcost = g_form.getValue('u_project_profitability').replace(/,/g,'')); //R//
var pr = parseFloat(projectrevenue);
var pc =parseFloat(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));

View solution in original post

18 REPLIES 18

Jaspal Singh
Mega Patron
Mega Patron

Hi Supriya,

 

Can yo try below.

var projectrevenue = g_form.getValue('u_total_revenue_per_milestone'); //U//

var parseprj=parseFloat(projectrevenue);
var projectcost = g_form.getValue('u_project_profitability'); //R//

var parseprjcost=parseFloat(projectcost);
var percentage=(parseprj-parseprjcost)/parseprj

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

i used below script

var projectrevenue = g_form.getValue('u_total_revenue_per_milestone'); //U//
var projectcost = g_form.getValue('u_project_profitability'); //R//
var pr = parseFloat(projectrevenue);
var pc =parseFloat(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));

 

projectrevenue  value is : 201,450  , but system considering  201 only.

find_real_file.png

any suggestions ?

Try below.

var projectrevenue = g_form.getValue('u_total_revenue_per_milestone').replace(/,/g,'')); //U//
var projectcost = g_form.getValue('u_project_profitability').replace(/,/g,'')); //R//
var pr = parseFloat(projectrevenue);
var pc =parseFloat(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));