This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am working with the In-Database tools, connecting to an SQL server. I am trying to divide two numerical fields and create a new field. The division should result in a decimal but the new field is showing only 0's.
Here is my SQL Expression that is created from the In-DB Formula tool:
"HD_Dist_Totals" / "Ind_Dist_Totals"
I have the Output Field creating new field as a Float Type. The end goal is to divide the two fields to create a decimal and then convert them to a percentage. My SQL knowledge is limited and I think that I am missing something in the statement, but my Googling has not helped.