I am trying to create a Run Rate% that estimates a revenue percent based on forecast with the following dataset properties:
- Q1 QTD Sum: Sum of revenue numbers from about 100 companies
- Days Elapsed in Q1 25: a calculated dataset property (verified) that counts the number of days from 1/1/25 to today
- 90: Number of days in Q1
- Current Q1 Forecast Sum: Sum of 100 Companies Qtrly forecast
The problem is that the formula won’t let me combine aggregate (I guess SUM) from non-aggregate dataset properties. See below. Today the number in the expression, [Days Elapsed in Q1-25] is a verifiable 17, however I must be missing a qualfier to translate it from #days to a number.
I would appreciate any help. Thanks!
Hi @SColeman9, I hope that you are well!
Thanks for asking the HubSpot Community!
I’d love to put you in touch with some of our Top Experts and Community Members: Hi @nthatcher-airbr, @Thrive, @basil, @Shuler, @bCubbit, @RSchweighart, @BRitter, @JTBuys and @Bryantworks do you have suggestions to help @SColeman9, please?
Also, I would recommend connecting with HubSpot Technical Support, as Support is included in your subscription and they will be able to provide real-time assistance for this matter, including hopping on a screenshare if necessary.
Have a great day and thanks so much! 
Best,
Bérangère
Hi @SColeman9,
Would you be able to provide screenshots as to how your three calculated properties are calculated?
There is a string_to_number function%20%3D%203-,string_to_number,-Convert%20a%20string) if one of your properties is a string, but I don’t think that’s the case.
When I input some arbitrary numbers, it calculates:
All the Best,
Ryan Schweighart
Whole Hart Impact, LLC
whimpact.co
I help businesses with HubSpot and Zapier.
Thanks very much Ryan - I figured out the issue, so I’m all set.
