In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

In-DB formula division - rounding down to nearest whole number

oracleoftemple
9 - Comet

Here's my situation.  I'm trying to use an In-DB Formula tool to divide two Int32 whole numbers.  I specify that the output should be Double so fractions will be displayed if applicable.  My formula looks like this:  ("Retail" / "Actual").  The problem is it's not including the remainder, i.e., it's rounding down to the nearest whole number.  So 4 / 5 gives me 0, when I want it to return 0.8.  8 / 5 gives me 1, when it should give me 1.6.  NOTE:  it's not rounding to the nearest whole number, otherwise 4 / 5 would have given me 1 and 8 / 5 would have given me 2.  It's just knocking off the fractional piece and rounding down.  Does anyone know how to fix this?  I know how to do it with a regular Formula tool, but the In-DB tool is SQL and I'm not quite sure what it is that I need to do differently.

1 REPLY 1
oracleoftemple
9 - Comet

Got it!

 

cast("Retail" as float) / cast("Actual" as float)

Labels
Top Solution Authors