Multiple Conditions not working

[junaidali0300]

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.

[Consumption:2,1]
Item|Consumed
{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?

Best,
Junaid

[Jesse]

Try this:

[Consumption:2,1]
Item|Consumed
{REPORT CONSUMPTION DETAILS: C.Name.asc, C.Consumption.Sum:(PCN=Beef Patty) AND C.Consumption > 0}

[Jesse]

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

[Jesse]

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

[Jesse]

This is that report:

[!Inventory Consumption:2, 1,1, 1, 1, 1, 1, 1.1]
>Item|[N]Used|Unit|[N]Pred|[N]InStock|[N]Added|[N]Removed|Warehouse
{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}