Hi All,

Just started to work with QuerySpec, great tool for what we're trying to achieve in retrieval queries for analytics on our data.

I wondered how you can select multiplied fields using QuerySpec, i.e.:

SUM(Orderitem.Quantity * OrderItem.Price) as Revenue

I've search for 'queryspec multiply' but couldn't find anything.

Thanks.

There is an example here in the documentation. You can just specify the fields in the expression:

.Select(OrderItemFields.Quantity * OrderItemFields.Price)
                    .Sum().As("OrderTotal")

Missed that one in the documentation, thanks.