The only possibility here would be a webhook. YOu would push the lead score and the max lead score, and it will return the highest of the 2. Hoosh has a new webhook accessible web service that can compute the max between 2 numbers, that you could store in the max field.
See Fab Capodicasa.
I'm guessing you're referring to Excel Formulas for Marketo – Marketo LaunchPoint
Wouldn't a webhook put an equal amount of strain on the system since it would call the webhook at every single lead score change?
1 of 1 people found this helpful
The webhook shouldn't cause additional strain unless your system already has a strain.
But this is far better done in SFDC, than in Marketo. Or with a BI tool.
You cannot use tokens in Triggers or to do comparisons. I think Greg has an Idea on that somewhere.