I'm very pleased to announce that this feature has been Delivered to all Professional and Enterprise customers. More information can be found on this in the following knowledge base article.
We could not have built this feature without your help. Thank you all for taking the time to submit, vote and comment on this Idea.
I have found myself in the same situation. have calcuated some values and would like the reports and dashboards to display the values as a currency format. I have not been able to figure a way to change the format of a calcuated property. If anyone has found a work arround. Please let us know.
Yes please!! The workaround we're using for this is to create the calculated property, then create a second Currency property, and create a workflow that simply copies the calculated property to the currency property.
Yes, an enterprise-level CRM requires the capability to display the output of a calculated property in currency format. If you multiply a currency property by a number, the result should be a currency format automatically.
In Deals, you also need to be able to accommodate which currency is used in the calculation. For a Deal in Euros, any Deal calculation properties on that Deal also need to shown in Euros.
Not including currency formatting as standard will mean that data in filtered Views, Dashboards and Reports may mislead the user.
I would also llike HubSpot to allow us to use three letter Currency Descriptors, so as to avoid confusion between American and Canadian Collegaues, who both use "$" in order to describe USD and CAD
Yes please provide all standard formatting for calculated properties. In fact, Hubspot should really build out calculated properties so they are closer to Salesforce calculated fields.
Ditto, Having to work round other Hubspot limitations (no currency conversion at deal item level, only being able to convert to a single company amount in reports) and then ending up with a poor display output is a real challenge
I'm currently having troubles working around the limitation you mentioned: "No currency conversion at deal item level"- How did you manage to work around that one?
The formatting option would definitely be useful on calculated fields! Until that's available as standard, I was thinking it should be possible to tweak the property to display currency (for example) using the API and a Postman tool patch operation. Unfortunately, I've haven't been able to tweak this successfully in my experiments so far. I get a 200 OK response, but no update to the setting seems to occur.
Currently running into this need as well. A calculated rollup field that sums currency fields should automatically be currency. At least give us the ability to manipulate through the API.
