Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi folks,
i have data like this.
emp no is promotion is manager
1 1 yes
2 0 no
3 1 no
4 0 yes
1. to generate report of managers, non managers ratio , how to create flag for manager, non manager?
2. to generate report of promotion, non promotion ratio, how to create flags
plz help me out in flag creation
Hi,
Try
For Manager to Non Manager ratio
Count({<[is manager= {'Yes'}>}EmpNo)/Count({<[is manager= {'No'}>}EmpNo)
For Promotion to Non Promotion ratio
Count({<[is promotion= {'1'}>}EmpNo)/Count({<[is promotion= {'0'}>}EmpNo)
Hope this helps you.
Regards,
Jagan.
Hi,
Flag is already there in your data. To get Ratio of Manager to Non Manager you can use
Count(If(IsManager='Yes',EmpNo)/Count(If(IsManager='No',EmpNo)
HI,
Using Set analysis
Count({<IsManager={"Yes"}>} EmpNo)
/
Count({<IsManager={"No"}>} EmpNo)
Deepak
Hi,
Try
For Manager to Non Manager ratio
Count({<[is manager= {'Yes'}>}EmpNo)/Count({<[is manager= {'No'}>}EmpNo)
For Promotion to Non Promotion ratio
Count({<[is promotion= {'1'}>}EmpNo)/Count({<[is promotion= {'0'}>}EmpNo)
Hope this helps you.
Regards,
Jagan.