flag creation problem

[#1]

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

[vijay_iitkgp]

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)

[deepakk]

HI,

Using Set analysis

Count({<IsManager={"Yes"}>} EmpNo)

/

Count({<IsManager={"No"}>} EmpNo)

Deepak

[jagan · Accepted solution]

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.