Grouping products by percentages in a report

  • Thread starter Middlemuir The Bear
  • Start date
M

Middlemuir The Bear

Hi

After successfully creating feed labels for animal feed I now have been told
that the raw materials that make up the feed need to be seperated into bands.
25% +, 24% - 10% and 9% below. At the moment the raw materials are
Concatenated. Each mix contains raw materials eg

mix 1 Steam Rolled Barley 335kg
mix 1 Steam Rolled Oats 290kg
mix 1 Steam Rolled Beans 150kg
mix 1 Hipro Soya 150kg
mix 1 Molasses 50kg
mix 1 Minerals 25kg

So the label should look something like this :

greater than 25% Steam Rolled Barley, Steam Rolled Oats, 10% - 24% Steam
Rolled Beans, Hipro Soya, less than 9% Molasses, Minerals

each mix doesn't always add up to 1000.

Thank you for your assistance.
PS the mix used is an example only and is not a ration that we make.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top