Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have a straight table:
Num | Store | Month | Count of A num | Sum of A linecost | Count of B num | Sum of B cost |
---|---|---|---|---|---|---|
WR | Sep | 1 | 357.5 | 0 | 0 | |
- | - | 0 | 0 | 4 | 0 | |
34563 | TE | Sep | 1 | 624.7 | 1 | 624.7 |
25677 | WE | Sep | 1 | 236 | 1 | 426 |
25677 | CG | Sep | 2 | 765.9 | 2 | 765.9 |
54796 | WR | Sep | 1 | 1643.7 | 1 | 1643.7 |
24560 | HJ | Sep | 1 | 6432.8 | 1 | 6432.8 |
'A' and 'B' were from different tables but I joined them together. In both tables, there are no blank values for 'Num', so why are there blank boxes for 'Num' when I create the straight table?
Thanks.
HI,
Because in table B there are 4 entries without Num or no store allocated to them.
Regards
ASHFAQ