Hello!
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.
Thanks for any help!
Solved! Go to Solution.
Okay, I think I figured it out. I set my SQL Expression as the following:
SELECT CAST("HD_Dist_Totals" AS FLOAT) / CAST("Ind_Dist_Totals" AS FLOAT)