report % (1 Viewer)

Ravi Kumar

Registered User.
Local time
Today, 14:07
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.
 

Attachments

  • Untitled.jpg
    Untitled.jpg
    71.8 KB · Views: 96

June7

AWF VIP
Local time
Today, 00:37
Joined
Mar 9, 2014
Messages
5,425
Then build expression in textbox that references textboxes with the data.
 

Ravi Kumar

Registered User.
Local time
Today, 14:07
Joined
Aug 22, 2019
Messages
162
hi june7,
as I am a beginner I didn't get you correctly if I build an expression can it automatically
update to successive rows also.??
could u pls send the syntax please .
Thank you for your time & help.
 

June7

AWF VIP
Local time
Today, 00:37
Joined
Mar 9, 2014
Messages
5,425
Textbox with expression will replicate for each record just the same as a textbox bound to a field. The expression will dynamically calculate using data from each record.
 

Ravi Kumar

Registered User.
Local time
Today, 14:07
Joined
Aug 22, 2019
Messages
162
dear june7,
As I already told you I am still learning , could u pls tell me the expression for this??
so that I can follow the same ??
 

Users who are viewing this thread

Top Bottom