on 01-20-2021 9:49 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for assisting kabras - much appreciated.
Regards
Bradley
User | Count |
---|---|
8 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.