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

[Jaspal Singh]

Seems you missed going through one of comments before.

[Pooja Devkar]

Hello Supriya, Refer below links for your query. It may help you to solve your query : https://community.servicenow.com/community?id=community_question&sys_id=e1307616db747388f7fca851ca961975 https://community.servicenow.com/community?id=community_question&sys_id=78421361db101fc01dcaf3231f9619f https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/field-administration/concept/c_CreatingAPercentCompleteField.html?title=Creating_a_Percent_Complete_Field#gsc.tab=0 Kindly mark my response correct and helpful, if its helpful to you. Thanks, Pooja Devkar Dxsherpa

[Supriya25]

Hi Pooja,

i just checked above links my issue is simple here 

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.

[Supriya25]

any suggestions ?

[Mike Patel]

try below

var projectrevenue = g_form.getCurrencyValue('u_total_revenue_per_milestone'); //U//
var projectcost = g_form.getCurrencyValue('u_project_profitability'); //R//
var pc = parseInt(projectcost).toFixed(2);
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));