Dataset issue combining aggregate and non-aggregate properties

[SColeman9]

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!

[BérangèreL · Accepted solution]

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

[RSchweighart · Accepted solution]

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 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. 

[SColeman9]

Thanks very much Ryan - I figured out the issue, so I'm all set.

[BérangèreL · Accepted solution]

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