Calculate value of a list of item in a datatype

Hi All,

I need some help with putting together a formula to calculate the value of a basket of assets in a datatype.

for example:

Datatype: Basket
Fields: Asset -> list of Asset (datatype) with quantity and price as fields. So the value of 1 asset is quantity of that asset * price.

The value of the Basket is the sum of all the value of individual assets in the basket.
I need to calculate the value of the Basket of assets.
How do I formulate this in Bubble?

Use … Calculate Formula … Calculate Sumproduct

1 Like

@NigelG

Thanks for the tip.

1 Like

Hi,
I have 3 lists: price, rentalTime and squareMeter and need to sum of products of 3 lists, how can I do that? thank you!