Simple Field Calculation

[nayfeh]

Hi,

I have a report that gathers data from a stored SQL procedure. One of the fields is "QtyOrderd". This lists the units ordered for each "ProductNbr".

I need to have a field that calculates the "TotalSkids" value. What this is, is OtyOrdered divided by 108 . Then, I need to get the remaining value and record that as a separate field in the report called "QtyLeftover". If the values of QtyOrdered is less than 108, say 64, then TotalSkids = 0 and QtyLeftover = 64.

Looks something like thisFor Quantities of 110 and 138)
----------------------------
ProductNbr TotalSkids
1 1
2 2
----------------------------
ProductNbr SkidsLeftover
1 2
2 30
----------------------------

Your help is appreciated.

Thanks,
TN

 

[PaulBricker]

I'm not quite sure why you have 2 for your TotalSkids in your example for ProductNr 2. 138/108 = 1 TotalSkid and 30 leftover. To calculate each one you can use these expressions.

TotalSkids = Int(QtyOrdered/108)
SkidsLeftover = QtyOrdered Mod 108

Paul