Thanks a lot for the answer. I finally achieve this using boost and scale function on top of my query https://wiki.apache.org/solr/FunctionQuery#scale
Thanks to scale no matter how big are the values or small on my People and Assignment Columns I can range them to a value between 1 and 2. {!boost b=sum(scale(PeopleTotal,1,2),scale(AssignmentsTotal,1,2))} -- View this message in context: http://lucene.472066.n3.nabble.com/Boost-by-Integer-value-on-top-of-query-tp4346948p4348329.html Sent from the Solr - User mailing list archive at Nabble.com.