Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
Branch | Customer | Target | Achieved |
Branch 1 | Customer 1 | 100 | 50 |
Branch 1 | Customer 2 | 100 | 20 |
Branch 1 | Customer 3 | 0 | 20 |
Branch 1 | Customer 4 | 0 | 40 |
Branch 2 | Customer 1 | 40 | 20 |
Branch 2 | Customer 5 | 0 | 50 |
A above is my transaction table
Output is
Branch | Target | Achieved | Without Target Achieved |
Branch 1 | 200 | 130 | 60 |
Branch 2 | 40 | 70 | 50 |
If target is 0 for the customer then in
Without target achieved column gets calculated. Is it possible????
Thanks Petter.
It's Working