I've created a report that groups by the item. In this grouping there are 3 items each with their own related quantity that takes to build the item.
For example say I want to make apple juice, it takes one teaspoon of sugar, one cup of water and 2 cups of lime juice to build one cup of apple juice.
Now, i want the user to enter how many apple juice they want to build, how can I get the information for each item in the grouping and calculate how much each item takes? Can this be done without a report?