Count of ID for Specific condition

[mhmmd_srf]

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

[Frank_Hartmann]

May be this:

=Count({<SupplierLotID = {"=aggr(Count(SupplierLotID), OrderNumber,OrderLine,AHPLotID) > 1"}>}  SupplierLotID)

[sunilkumarqv]

Please try this

=Sum(<SupplierLotID = {"=Count(distinct SupplierLotID) > 1"}>}Aggr(Count({<SupplierLotID = {"=Count(distinct SupplierLotID) > 1"}>} Distinct SupplierLotID), OrderNumber,OrderLine,AHPLotID)).