Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
Please see my attached sample model.
In the report , The status condition works base on calculation of the fields Stock on hand, Actual receipts, and Forecast units.
How to make the status filter work when selected ; "Stock out" or "No Stock Out".
May be with a calculated dimension
=Aggr(If(GetSelectedCount(Status) = 0, [Product/Code],
If(GetFieldSelections(Status) = 'Stock Out', if(sum(SOH)+sum(purchase_receipts)< (50/100 * sum([Forecast Units])), [Product/Code]),
If(GetFieldSelections(Status) = 'No Stock Out', if(sum(SOH)+sum(purchase_receipts) >= (50/100 * sum([Forecast Units])), [Product/Code])))), [Product/Code])
May be with a calculated dimension
=Aggr(If(GetSelectedCount(Status) = 0, [Product/Code],
If(GetFieldSelections(Status) = 'Stock Out', if(sum(SOH)+sum(purchase_receipts)< (50/100 * sum([Forecast Units])), [Product/Code]),
If(GetFieldSelections(Status) = 'No Stock Out', if(sum(SOH)+sum(purchase_receipts) >= (50/100 * sum([Forecast Units])), [Product/Code])))), [Product/Code])