Asking here to persist the solution.

Following situation:

object basket with:

```
property name="items" relationship="one-to-many" relatedto="basket_items" relationshipKey="basket";
property name="items_count" type="numeric" formula="agg:sum{ items.amount}";
```

object basket_items with:

```
property name="amount" type="numeric" default="0";
property name="unitprice" type="numeric";
property name="sum" type="numeric" formula="${prefix}amount* ${prefix}unitprice";
```

The items are calculated correctly, but I’d like to get the price of the whole basket.

I tried:

```
property name="total" type="numeric" formula="agg:sum{ items.sum }";
```

returns in: `Unknown column 'items.sum' in 'field list'`

Also `formula="agg:sum{ items.amount * items.unitprice }"`

and `formula="sum(${prefix}items.anzahl * ${prefix}items.nettopreis)"`

result in an error.

Is there a simple way to get the full amount of the whole basket?

Thanks

Michi