Formula Help

You could make a formula checkbox, with your really long rule in it, and then use that checkbox in the report. However, I think a much better approach is to create two new fields.

[Minimum quantity needed on hand] - numeric field
[Is quantity on hand less than minimum quantity?] - formula checkbox

Checkbox formula would be: [Quantity On Hand] < [Minimum quantity needed on hand]

Run through all of your sku's and manually set the minimum quantity needed on hand.

Then simply use the checkbox formula in your report. This is also nice because you can use that checkbox formula in subscriptions (every monday send out a report where that is checked...etc). You can use it in reports to color code rows (highlight rows red that the quantity on hand is too small).

Also, you can just run through the few hundred parts you need to track and add the minimum number. As part of your filter you can add in the rule 'Only show parts where the [Minimum quantity on hand]>0, or something like that. This would limit your list just to that 100. Or you can say, only show me parts where the checkbox is checked. That really limits it.

------------------------------
Mike Tamoush
------------------------------