Rizky Tony
New Member
Hi Guys,
I am having problem to ignore the combination (if already counted before) to count some thing..
PO Number Activity Quantitiy 1 Quantitiy 2
a 3 1 0
a 3 2 0
a 2 0 0
a 1 1 0
a 1 3 2
a 1 4 4
b 1 1 1
b 1 0 0
b 2 0 0
b 2 1 0
Hopped result
Q1 Q2 Notes
a activity # 2 1 Number of activity having Qyt at least 1 for PO a
a quantity # 11 6 Number of Quantitiy for PO a
b activity # 2 1 Number of activity having Qyt at least 1 for PO b
b quantity # 2 1 Number of Quantitiy for PO b
Thank you for reading and helping
BR//RT
I am having problem to ignore the combination (if already counted before) to count some thing..
DataPO Number Activity Quantitiy 1 Quantitiy 2
a 3 1 0
a 3 2 0
a 2 0 0
a 1 1 0
a 1 3 2
a 1 4 4
b 1 1 1
b 1 0 0
b 2 0 0
b 2 1 0
Hopped result
Q1 Q2 Notes
a activity # 2 1 Number of activity having Qyt at least 1 for PO a
a quantity # 11 6 Number of Quantitiy for PO a
b activity # 2 1 Number of activity having Qyt at least 1 for PO b
b quantity # 2 1 Number of Quantitiy for PO b
Thank you for reading and helping
BR//RT