Troubleshooting Score Row in Clay Enrichment for Negative Values | Clay

Troubleshooting Score Row in Clay Enrichment for Negative Values

I want to use the Score Row in Clay enrichment and trying to score negative values between -100 and - 1 with a score of 1. I am using the Between Comparison number and keyword "-100 - -1" and a score of 1 but it doesnt return 1. What am I doing wrong?

6 comments

Channeled
APP
·
·
To assign a score of 1 to values between -100 and -1 using the Score Row in Clay enrichment, you should use the correct numeric comparison operators. The "Between" comparison typically expects a range in the format "min max" (e.g., "-100 -1" without the extra dash or space). Try entering the range as -100 -1 (no extra spaces or dashes) in the Between Comparison field. This should match any value greater than or equal to -100 and less than or equal to -1, assigning a score of 1 to those values. If the field expects two separate inputs for min and max, enter -100 as the minimum and -1 as the maximum. If you continue to have issues, double-check that the field is set to numeric comparison and not string comparison, as string comparison may not handle negative numbers as expected , .
Sources: Score Row in Clay with Clay Comparison operators | Documentation | Clay University
David
·
·
I put -100 -1 in the keywords but it still doesnt work
David
·
·
https://app.clay.com/workspaces/579323/workbooks/wb_0svjbdljq5qtiUNuhNz/tables/t_0svjbmjShTj7joRBUBN/views/gv_0svjbmkD2Gwjm99HgGf
Bo (.
·
·
Hey David, do you have a specific row where this is happening? I checked the table, but there’s a lot of data, so it’s hard to pinpoint. Happy to take a look and help you get the scoring rule working correctly.
David
·
·
Hey its the headcount growth role. I didnt recognize the negative numbers. If you could create a row where it just scores the negative number between -1 and -10 with a 1 that would be amazing!
Bo (.
·
·
Hey, I updated the formula for you. I took your message, copied the AI formula, and worked with the LLM to adjust the JavaScript so it now scores negative values between -1 and -10 with a 1. Just a heads-up—Claygent doesn’t pull from social media, so some values might not be fully accurate. Let me know if you want to tweak anything further.