I've got a couple of tables that are related by a lookup column:

Orders:

OrderNumber

Value

Deliveries:

OrderNumber

DeliveredDate

I'm trying to generate a report that gives me a count of deliveries and a sum of their value for a given month of delivery dates.

i.e. Deliveries in January: 5, totaling £12,000

However, whenever I try and do this I get the following error:

Sorry, you cannot have numeric column(s) ('Column,Column4'), from the parent table ('Untitled-1')", when text/date columns ('DeliveryDate') from the child table ('Deliveries') are involved.

I've attached a screen grab of how I'm trying to generate the report.

Can anyone offer some advice on what I'm doing wrong?

Thanks,

Robert