Multiple Conditions not working

Hello, I am filtering multiple items from the inventory report with {REPORT CONSUMPTION DETAILS}. So far added one condition but want to add another condition on the items I can see in the report.

{REPORT CONSUMPTION DETAILS: C.Name.asc, C.Consumption.Sum: C.Consumption > 0}

More specifically, the string filters aren’t working. I want to add above condition and filter the items as well. What’s the mistake in this?


Try this:

{REPORT CONSUMPTION DETAILS: C.Name.asc, C.Consumption.Sum:(PCN=Beef Patty) AND C.Consumption > 0}

Then you can do some more advanced reports with something like this with pivot tables:

Here is same pivot table with some formatting of the design.

This is that report:

[!Inventory Consumption:2, 1,1, 1, 1, 1, 1, 1.1]
{REPORT CONSUMPTION DETAILS:C.Name.asc,C.Consumption.Sum,C.Unit,C.Inventory.Sum,C.InStock.Sum,C.Added.Sum,C.Removed.Sum,C.Warehouse:C.Consumption>0}