How to return the quotient of a division?

[FLOWPA]

I searched, but couldn't find a solution to obtain the quotient of a division.

The Excel related function would be QUOTIENT(). PowerApps doesn't have it, it only has MOD().

How could I return the quotient of a division?

[RandyHayes · Accepted solution]

@FLOWPA 

The Quotient formula in Excel only returns an integer of the division, so the equivalent would be:

   RoundDown(numerator/denominator, 0)

I hope this is helpful for you.

[jblomberg]

First off I should mention I have no knowledge of Excel, so I'm unfamiliar with the quotient-function that's used there. But since the quotient is the 'answer' of the division, I wonder what you're trying to do, because getting this answer is straightforward. 

When dividing 6 by 3, the quotient is 2. So if you set the X-value (just one of many possible examples) of a control to

6 / 3

the X-coordinate will be the quotient (2). If this was set on a label control, getting the quotient could be done by referencing Label1.X

Setting a variable with the quotient of whatever you're dividing works the same:

Set( varQuotient, Dividend / Divisor)

But maybe I'm not understanding correctly. If so, please elaborate on what you want to achieve.

Hope it helped!

[FLOWPA]

@jblomberg Thank you, this is what I am trying to achieve link

I need to divide the total gallery items / increment (25) , and display in a dropdown box 25, 50, 75, 100, up to the total gallery items. 

[FLOWPA]

---

@RandyHayes wrote:

@FLOWPA 

The Quotient formula in Excel only returns an integer of the division, so the equivalent would be:

   RoundDown(numerator/denominator, 0)

I hope this is helpful for you.

---

@RandyHayes That's what I was looking for, many thanks!