Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everybody,
I have a start date, end date and salary column for employees and I want to calculate phased salary. For instance, A earn 48000 per year. The start date is April 8 and the end date is July 1. The phased salary equals to 48000/12*2.25. Any advice will be greatly appreciated. Thanks!
Solved! Go to Solution.
Try using DATEDIFF to add a calculated column.
Try using DATEDIFF to add a calculated column.
Why 2.25? Explain.
Hi,
If someone starts on April 8, he works for 23 days in that month and thereafter for the 2 complete months. How does that become 2.25?
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
73 | |
65 |