Rollup using a group of results from linked table

[Simon_Horwood1]

Hi guys, I am having trouble with an ROLLUP function hoping for some help.

See LOOM video attached

How on earth can I ROLLUP using a GROUP of results from a list.

Essentially this is my workflow plan.

APP: to create a Nutritional Label from data sources in the airtable data.

Workflow:

1. Create new recipe

2. Assign (link) ingredients to the recipe based on linked fields.

3. Group the ingredeients linked to that recipe.

4. Use formulas to create nutiriontal values based on the values from the linked ingredients.

Where I am getting stuck is grabbing the values from a group of ingredients, especially in a ROLLUP.

Loom

18 January, 2021 - Loom Recording

Check out a video I made via Loom

[Hossam_Khedr]

Hi Simon,

Try loosing the condition. I tested a similar but much simpler base without the condition and used ARRAYJOIN(values) in the aggregation formula, it worked perfectly well.