Monthly Consumption report - duplicate inventory items

V5 Question
1

Hi there,
I’ve created a report that used to create the consumption report, but when i select an entire month, i’ve found that there are some duplicate inventory items.
Here is my code:

{REPORT CONSUMPTION DETAILS:
    C.Name,
    C.Warehouse.asc,
    C.Unit,
    C.InStock,
    C.Consumption,
    C.Inventory,
    C.Cost,
    ([C.Consumption]*[C.Cost])
:C.Consumption != 0:"{0}","{1}","{2}","{3}","{4}","{5}","{6}","{7}"}

Can i GROUP by inventory item and SUM the values somehow? Thanks!

Best regards,
Keri

2

In report tags you have trailing field expressions like;
C.Name.Sum

3

Hm…it’s not working :frowning: I get an empty result (both export and in-app report).

4

Anybody with a suggestion? :slight_smile: