Adding together numerical values of different fields.

Anonymous
Not applicable

Adding together numerical values of different fields.

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 
Tags (1)
2 REPLIES 2
Level 5

Re: Adding together numerical values of different fields.

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. 
Anonymous
Not applicable

Re: Adding together numerical values of different fields.

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