Filter for Decimal/Pack quantities that have been broken up.
Fred Office reporting to have a filter than can only filter for QTY amounts that are not whole numbers.
Similar to the =A1-TRUNC(A1) (A1 is the cell you want to extract decimal value from) formula in excel where it can bring forth amounts that are in decimals.
2
votes
Greg
shared this idea