harshadborde
Registered User.
- Local time
- Today, 06:55
- Joined
- Apr 10, 2017
- Messages
- 17
I am working on a project of excel transformation. In excel we have columns Emp Id (A), Project Id (B), Project Role (C ), Location (D) and Salary. We have salary almost all a employees. But for those we do not have we calculate salary taking average of B,C,D / C,D / D. We want only one salary per combination of ABCD.
e.g. John working in Project Id X as Manager in London will have salary Y. If his project id is missing then we will calculate his salary based avg of C and D.
I designed 3 separate queries to calculate salary and but facing problem of duplicate records.
Any help in design/ logic and query will be much appreciated.
e.g. John working in Project Id X as Manager in London will have salary Y. If his project id is missing then we will calculate his salary based avg of C and D.
I designed 3 separate queries to calculate salary and but facing problem of duplicate records.
Any help in design/ logic and query will be much appreciated.