cancel
Showing results for 
Search instead for 
Did you mean: 

C4C Opportunities - Weighted Value

bmursell
Participant
0 Kudos

Morning Experts,

We have a requirement regarding C4C opportunities, whereby our users would like to see additional text (descriptions) in a custom Probability field we have created. There are several percentages to choose from and if maintained, the opportunity value is multiplied but the probability percentage (e.g. opp value £30,000 x 50% = £15,000) which populates the Weighted Value field. However, applying text to the Probability field causes an error as you would expect.

Just wondered if anyone else has had a similar request, or if there's a recommended approach if not possible to add text to the Probability field. Example attached - weighted-value.png. The Probability shows list values with an example of the required text.

Many thanks

Bradley

Accepted Solutions (1)

Accepted Solutions (1)

former_member226
Employee
Employee
0 Kudos

Hello,

I believe you have written a custom logic in PDI to map the Custom Probability field for weighed value calculation. If thats the case then i think with a little bit of coding(string, sub-string with RegEx) it should be possible to extract the numerical value from the text field and then multiply the text value with the expected value to get the weighed value.

A sample code could look like as follow:

var prob = "Agreed 50%";  // Assuming the value selected
var start = prob.FindRegex("[0-9]+",0);
var end = prob.Find("%",0);
var number = prob.Substring(start,end-start);

Thanks

bmursell
Participant

Thank you for assisting kabras - much appreciated.

Regards

Bradley

Answers (0)