I have this Output with Expression (HIT AND MISS)
-------------------------------
Qty1 | Qty2 | HIT/MISS
10 10 HIT
15 14 MISS
20 20 HIT
23 23 HIT
----------------------------
HIT/MISS - has the Expression:
=Iif(Qty1.Value = Qty2.Value, "HIT", "MISS")
*now I need to COUNT the number of HIT and the Number of Items
output should be:
-------------------------------
Qty1 | Qty2 | HIT/MISS
10 10 HIT
15 14 MISS
20 20 HIT
23 23 HIT
HIT: 3 / 4
----------------------------
3 hits in 4 items.
the hard part of this is that the Values are Group, meaning the 4 Values of Qty1 and Qty2 are just SUM of the Group Item.
please help me achieve this output. thanks.
