# Formula Help

Ok,

I have been trying to build a report formula and am struggling to find the right "formula".

I feel it's a unique situation as google, the formula builder and support haven't been much help.

I have created a report that has "if the name is ABC and the Quantity is XYZ, then show it.

However, I've run out of filter options.

I need to do this for roughly 100 filter parameters.

We use THOUSANDS of parts. But I only need to see the most commonly used.

Example:

"Sku is equal to the value P80U114 AND the Quantity on hand is equal to or less than 5"

or

"Sku is equal to the value P80TUBV1 AND the quantity on hand is equal to or less than 3"

etc...

we have many many skus we need data on. But the only formulas I can find is "If ABC is XYZ AND DEF is UVW then CHANGE Value to LMNOP"

I don't need to change values, I just need to see them.

Attached is a screenshot of what the type of report I am needing is.

------------------------------

Newman, Savi

------------------------------