Trying to add multiple values brought in by a relation

[holysheets]

Have multiple values brought in, for example, I am using date as the primary relation to bring in items sold on that date into one feed using the Relation values, but how do I use Math to add up the values in this Look up table.

But I think I figured it out.

Math: ROLLUP →

[Darren_Murphy]

Yes, you have a multiple relation, and so your lookup column returns an array. And you can’t use an array in a math column.

What you can do is bypass the lookup column and target the rollup directly at the Revenue column via the relation.