I have few custom pages in opportunity workflow. The data is added to the opportunity progress table whenever the opportunity data is updated. Everything works fine except Opportunity duration. How can I insert value to opportunity duration. I am know it is a system calculated field based on business calendar defined. How to get the calculation used so that I can insert to opportunity progress table whenever a custom page is updated?
Is there any field in CRM that store the duration field? Or how can I calculate the duration time?
Hi Sulfath Shajahan,Thanks for reaching out. Did you ever find a resolution to this issue? If you are still looking for guidance, please let us know and we can try to point you in the right direction or suggest some resources or next steps.Warm Regards, Erzsi
Yes. I managed to write one store procedure which calculates the time taken in each stage based on the business calendar. It works pretty well as expected.
I will be glad to know if any other way or directions you can give or an alternative way of doing the same