Adding together numerical values of different fields. | Community
Skip to main content
April 19, 2013
Question

Adding together numerical values of different fields.

  • April 19, 2013
  • 2 replies
  • 1953 views
I am trying to build a campaign that will trigger an email to users if the collective value of a number of fields is below a threshold, after a certain period of time.

These fields are all numerical so I need a way of creating a formula that will add these values together.

Is this possible in Marketo?

Thanks

Carey 
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Amy_Lepre
Level 6
April 19, 2013
I think so. I've not done this before, but the way I would start to approach it would be to create the collective fields using a field type of score. Then create a formula field to add those score fields together. Create a smart campaign to look at the value of the formula field, then trigger the email based on that value. 
April 19, 2013
It is if you convert the integers to  score field types but a much easier appoach is to do the calculation in the CRM instead. Natively Marketo does not have any numerical math functions other than +/- on score fields

Cheers,
Eric