Hello All,

I have this fields these fields

Material Quantity Received - Number field

Material Quantity Used - Number field

Material Stock - calculation ( Material Quantity Received - Material used)

Quantity in each Container - Number field

Number of Container - ?

How can I determine the number of containers remaining base from my Material Stock?

Thank you.

LoLa

How would you do it using pencil and paper?

What I don't see that I would expect for that calculation is some value that tells me how many containers there are before the material documented in this record is used to fill some of them. From the info provided in your example, I can compute the number of containers needed, but need more info to determine how many should then remain.

The number of containers needed for the material in this one record:

Ceiling ( Material Stock / Quantity in each Container )

This assumes that you keep each container but one filled to capacity.