Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Do anyone know the calculation of Demand ROI field?

serene_ly_oh
Giga Contributor

What I have got from Project is

  Planned ROI% :The result is calculated based on values in the Planned return and Estimated cost fields. (Planned return/Estimated cost x 100) but does not seems to be correct for Demandfind_real_file.png

find_real_file.png

1 ACCEPTED SOLUTION

Hi Anurag,



thank you for your reply.


Apparently the value we have is not showing as calculated value. However, I have managed to find a business rule on this calculation. Thank you for your advise once again.


roi.jpg


View solution in original post

2 REPLIES 2

Anurag Tripathi
Mega Patron
Mega Patron

Hi Serene,



This is a calculated field, if you right click on the field and go to the dictionary you can see the calculation.



Here is the calculation i have in my personal instance(Fuji)



var financial = current.financial_return || 0;


var total_costs = current.total_costs || 0;


var ret = null;


if (total_costs > 0)


  ret = Math.round((parseFloat(current.financial_return)/parseFloat(current.total_costs)) * 100);


ret;


-Anurag

Hi Anurag,



thank you for your reply.


Apparently the value we have is not showing as calculated value. However, I have managed to find a business rule on this calculation. Thank you for your advise once again.


roi.jpg