Way to get quotient integer like QUOTIENT function in excel

[DataUser]

Is there an opposite to the MOD function? I'm looking for some function or way to get the quotient integer (so not including the remainder) like the Quotient function in excel. Is there a Alteryx formula for this or a work around that would yield this result?

[jdunkerley79 · Accepted solution]

If you are dealing just with postive values then:

FLoor([Numerator]/[Denominator])

will work

For general case, it is a little more work:

Floor(Abs([Numerator]/[Denominator]))*IIF([Numerator]/[Denominator]>0,1,-1)

[DataUser]

Great thank you!