Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to calculate count of SupplierLotID against three layer OrderNumber,OrderLine, AHPLotID where count (SupplierLotID) >1.
I am using below expression:
=Sum(Aggr(Count({<SupplierLotID = {"=Count(distinct SupplierLotID) > 1"}>} Distinct SupplierLotID), OrderNumber,OrderLine,AHPLotID)).
It is not showing correct value.
I am attching my App. Please check "Order Line Count for Multiple" section.
If I select Date= 7 Mar 2017 , it should come as 2.
Please help.
Thanks,
Sarif
May be this:
=Count({<SupplierLotID = {"=aggr(Count(SupplierLotID), OrderNumber,OrderLine,AHPLotID) > 1"}>} SupplierLotID)
Please try this
=Sum(<SupplierLotID = {"=Count(distinct SupplierLotID) > 1"}>}Aggr(Count({<SupplierLotID = {"=Count(distinct SupplierLotID) > 1"}>} Distinct SupplierLotID), OrderNumber,OrderLine,AHPLotID)).