FJMSalgueiro
New member
- Local time
- Today, 00:44
- Joined
- Jan 18, 2024
- Messages
- 1
I am trying to create an expression to give me the count of PO + PO Line but I keep getting the wrong results. See some samples below in red.
Shipped Orders Query Count
PO PO Line Expr1
Shipped Orders Query Count
PO PO Line Expr1
| 1 | 1 | 2 |
| 2225392 | 1 | 1 |
| 2225397 | 1 | 1 it should be 2 |
| 2225397 | 2 | 1 |
| 2225971 | 1 | 1 is should be 3, etc |
| 2225971 | 2 | 1 |
| 2225971 | 3 | 1 |
| 3060248 | 1 | 1 |
| 3060248 | 3 | 1 |
| 3060248 | 5 | 1 |
| 3060387 | 1 | 1 |
| 3060387 | 3 | 1 |
| 3061967 | 30 | 1 |
| 3061967 | 31 | 1 |
| 3061967 | 45 | 1 |
| 3062166 | 1 | 1 |
| 3062168 | 50 | 1 |
| 3062169 | 2 | 1 |
| 3062170 | 1 | 1 |
| 3062173 | 1 | 1 |
| 3062178 | 8 | 1 |
| 3062178 | 12 | 1 |
| 3062179 | 5 | 1 |
| 3062180 | 1 | 1 |
| 3062464 | 1 | 1 |
| 3062521 | 1 | 1 |
| 3062522 | 1 | 1 |
| 3062671 | 1 | 1 |
| 3062964 | 1 | 1 |
| 3063854 | 5 | 1 |
| 3063857 | 1 | 1 |
| 3063858 | 1 | 1 |
| 3063859 | 1 | 1 |
| 3063862 | 1 | 1 |
| 3063863 | 1 | 1 |
| 3063864 | 1 | 1 |
| 3063865 | 1 | 1 |
| 3063928 | 1 | 1 |
| 3063954 | 1 | 1 |
| 3063954 | 2 | 1 |
| 3063954 | 3 | 1 |
| 3063954 | 4 | 1 |
| 3063954 | 5 | 1 |
| 3063954 | 6 | 1 |
| 3063954 | 7 | 1 |
| 3063958 | 4 | 1 |
| 3063986 | 1 | 1 |
| 3064012 | 2 | 1 |
| 3064113 | 4 | 1 |
| 3064114 | 1 | 1 |
| 3064448 | 1 | 1 |
| 3065232 | 1 | 1 |
| 3065232 | 2 | 1 |
| 3065610 | 1 | 2 |
