Here, I am trying to create a numeric column for HCPs count through the shown calculated field shown in the image.
1 answer
Change the Total from Auto to Sum
see https://jimdehner.com/2023/02/28/grand-total-and-sub-total-use-cases/ for more on totals