1 Reply Latest reply on May 31, 2017 2:28 PM by Sanford Whiteman

    Check score sums

    Raul Ocaña

      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

        • Re: Check score sums
          Sanford Whiteman

          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.

          1 of 1 people found this helpful