2 Replies Latest reply on May 21, 2012 4:04 PM by hub.yoo

# Determining if a product falls within stocking levels

Hello,

I am trying to do a report on if stocking levels are "below min", "within range" or "above max". I should be getting one of the three values per catalog number but instead I get "below min" first with a corresponding value of what the minimum is. Then if the quantity at hand is larger than the min, I get a value for "within range"... and if the quantity is above the maximum, the remainder is presented on the "above max line".

For example: The first catalog_no below, the quantity in stock is 683 units. The min is 311 units. Max is 800 units. Since its lower than the max, the minimum shows up, and the remained shows up on the within range.

Calculation used:  If [Qty] > [Max] Then "Above Max" elseif [Qty] < [Min] then "Below Min" else "Within Range" end

I've made a dummy workbook that works fine using the calculation i made for this...  any enlightenment would be greatly appreciated.

Thank you very much.

• ###### 1. Re: Determining if a product falls within stocking levels

Hi Hub,

If I understand correctly, then the calculation needs to simply be changed to the following:

If sum([Qty]) > sum([Max]) Then "Above Max" elseif sum([Qty]) < sum([Min]) then "Below Min" else "Within Range" end

Hope this helps!

-Tracy

• ###### 2. Re: Determining if a product falls within stocking levels

Thanks Tracy for the reply, and yes it worked perfectly