Now that we can create calculated Line Item properties, I am trying to create a property that uses the Term in the calculation. However the Term property is a string (eg. P12M) rather than a number. I’ve created a new “Line Item Term in Months” property but does anyone have any suggestions on how to convert the Term into a number? I know how to do it in Excel (using the SUBSTITUTE function) but this isnt available in HubSpot calcualted properties. I tried using the String-to-number function but it doesn’t wok as there are letters in the Term property.
Convert Line Item Term to a number
Related Post
Line Items Quarterly ReportLine Items Quarterly Report
Hi, I’m trying to create a report using Line Items.For example, I created a new line item named “A” with a Total Contract Value (TCV) of $50 million and a
IntroIntro
Hello everyone. My name is Emeka. I started learning marketing and communication. I hope to participate here and grow with the hubspot.
Issue with HubSpot iFrame Closure in Public App SettingsIssue with HubSpot iFrame Closure in Public App Settings
Hello, We have observed an unexpected behavior with embedded iFrames in HubSpot: When a user closes the iFrame via the HubSpot UI in the settings screen of a public app,