Check score sums

[Anonymous]

Hi guys,

We have 3 score fields (Total, Behavior and Demographic). And some users noted that some leads have a total score different from the sum of the B-score and D-score.

Now I want to create a report of what leads have this issue. Is there a way to filter like "if field1+field2 != field3" so I can fix them?

Regards,

Raúl

[SanfordWhiteman · Accepted solution]

You can't do a filter like this natively.

Even if you could, it would probably take as long to process the Smart List in Marketo as just to reset the value for all your leads.

If you have FlowBoost, you could do

if ( +{{lead.field1}} + +{{lead.field2}} != +{{lead.field3}} ) {
  var irregularTotalScore = true;
}

Then trigger on Webhook is Called, Response [contains] "irregularTotalScore" → Add to List.

But again, running your whole db through something like this, where you can (re)set the same value in a Flow, is probably not an improvement.