Hi,
I have an optionset (Probability %) that has values 10, 25, 50, 75 and my opportunity form has a weighted opp value field which basically takes the (Total Value * probability)/100.
How do I change the value in the Probability option set into a currency type (Total Value and opp value are both currency) and perform the calculation?
Thanks
*This post is locked for comments
Hi Guido,
Thanks for the response. However, I'm getting the error that I need to enter a value between the range of -1,000,000,000.0000 to 1,000,000,000.0000,
This is the error I get even with replacing the code:
My code is:
function calculateTotal()
{
var soft = Xrm.Page.getAttribute("new_softwarerevenue").getValue();
var serv = Xrm.Page.getAttribute("new_servicerevenue").getValue();
var dev = Xrm.Page.getAttribute("new_developerrevenue").getValue();
var oth = Xrm.Page.getAttribute("new_otherrevenue").getValue();
var tot = Xrm.Page.getAttribute("new_totalestimatedrevenue");
var add = soft+serv+oth+dev;
if(soft !=null || serv != null || dev != null || oth != null)
{
tot.setValue(add);
}
else {return;}
var probability = Xrm.Page.getAttribute("new_probability").getText();
if (probability != "")
{
var percent = parseFloat(probability);
var oppValue = tot * percent/100;
Xrm.Page.getAttribute("new_opportunityvalue").setValue(parseFloat(eval(oppValue)));
}
}
@Guido: Thank you much! It worked!
@Karth: Thank you for your input. That code will def guide me to use it appropriately in future cases!
Share
Report
All responses (
Answers (
