How do you calculate a % field in Marketo?

Forum|Forum|10 years ago
August 21, 2015
3 replies
3789 views

I have 2 fields in Marketo populated with numbers. I have a third field created to hold the % of the other two fields.

The problem is I don't know how to create a formula in the third field to generate the percentage of field 1 and field 2.

I am hoping to figure out a way of doing this without having to develop Javascript or use an API ...

HELP please

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

Josh_Hill13

Level 10

Make the third field a formula field. There are instructions in docs.marketo.com.

A

Anonymous

Hi Josh,

I've always used the API or Javascript for this function and haven't been able to find much on use cases and application for the Formula field.

Do you happen to have a resource that shows 'Field Math' using a formula field? You seem to really know the platform so I'm hoping you have some insight. Is this something most people just do in SalesForce?

The example in the product doc is not quite the same as doing a calculation. It is more determining a static value based on another field's value.

Create and Use a Concatenated String (Formula) Field - Marketo Docs - Product Docs

It seems Marketo can do simple + and - calculations, but true field math seems difficult without an external script

Re: Change Data Value = Date + X Days

Re: Adding together numerical values of different fields.

Josh_Hill13

Level 10

It helps to read the docs

Create and Use a Concatenated String (Formula) Field - Marketo Docs - Product Docs

my assumption was wrong. It is best to run formulas in SFDC instead or with a webhook or something else. I've run into some challenges where the SFDC formula field might not show up right in Marketo, but I think that was only with a lookup field.