Hi there, we use HubSpot Entereprise for several regions accrose the globe with different currencies. Currently the Company Currency is set as US Dollars and this currency is being used by “Deal Revenue Forecast by Stages” report. I was told that its not possible to create a version of this report based on a regional currency.
I am trying to create a custom version of this report using “Amount” property instead of “Amount in Company Currency” (we are able to enter deal amount in our regional currency in the “Amount” field) . The challenge is to calculate to weighted deal amount based on deal probability stage. This amount has to dynamically change when a deal is moved to the next stage. I found one way but not sure if it’s ideal:
- Create a numbered Probability property and set the value in this field using a workflow (e.f. of Deal Stage is 10%, set Probability to 0.1, if Deal Stage is w0%, set Probability to 0.2 etc.)
- Create a custom Weighted Amount calulated property that equals Amount x Probability.
My only question is how to ensure that Deals go through this workflow each time their Stage changes so that Probability is dynamically updated based on the Deal Stage.