Making Simple Calculations using Portals
I'm trying to make nutritional calculations for a recipe item based on a total calculation for each ingredient. The relational database is a list of raw ingredients and nutritional information. Note: In this example the 230 calories is a recommended service of 3 meatballs. In this case my ingredient factor is 5 meatballs, or 383 calories. You can see I get the same Calories_service for each ingredient, which is obviously wrong. How do I make these line item calculation like in a table?