Ravi Kumar
Registered User.
- Local time
- Tomorrow, 03:31
- Joined
- Aug 22, 2019
- Messages
- 162
dear all ,
in my report I have 5 columns:
1. Area
2. Planned leave(Hrs)
3. unplanned leave(Hrs)
4. Absenteeism(Hrs)
5. Total OT(hrs)
now at the second row I need percentage like below:
1. below sum of Planned leave(Hrs) - I need % of(Planned leave(Hrs)/(Planned leave(Hrs)+unplanned leave(Hrs)) of that particular area.
same like this for other 3 columns also.I have attached a file for your reference.
kindly some one help me.
in my report I have 5 columns:
1. Area
2. Planned leave(Hrs)
3. unplanned leave(Hrs)
4. Absenteeism(Hrs)
5. Total OT(hrs)
now at the second row I need percentage like below:
1. below sum of Planned leave(Hrs) - I need % of(Planned leave(Hrs)/(Planned leave(Hrs)+unplanned leave(Hrs)) of that particular area.
same like this for other 3 columns also.I have attached a file for your reference.
kindly some one help me.