HI guys
I need to put multiple coniditions on my table based on some combinations.
Here is my main table-
Practitioner
DHBName
PHOName
Practicename
PractitionerName
Locum
YCount
NCount
4
Canterbury DHB
Partnership Health (Canterbury)-596721
Linwood Avenue Medical Centre
Christine Abbasi
No
0
1
32
Canterbury DHB
Partnership Health (Canterbury)-596721
Felicia House Clinic (Pearson)
Nicci Pavey
No
0
1
197
Canterbury DHB
Partnership Health (Canterbury)-596721
Woodham Road Health Care
Peggy Shelton-Agar
No
0
1
394
Hawkes Bay DHB
Hawkes Bay PHO Limited-587862
The Doctors Napier
John Laird
YES
1
0
549
Canterbury DHB
Partnership Health (Canterbury)-596721
Linwood Avenue Medical Centre
Denise Armstrong
No
0
1
1286
Canterbury DHB
Partnership Health (Canterbury)-596721
Darfield Medical Centre Limited
Katherine Muscroft-Taylor
No
0
1
1501
Counties-Manukau DHB
Procare Network Manukau Limited-573183
Manukau City Health Centre
Caroline Shephard
YES
1
0
1932
Hawkes Bay DHB
Hawkes Bay PHO Limited-587862
Clive Medical Centre Ltd
Karen Irwin
YES
1
0
2226
Canterbury DHB
Partnership Health (Canterbury)-596721
Sumner Health Centre
Anne Scott
No
0
1
3243
Waitemata DHB
Harbour PHO Ltd-610733
Byron Medical
Rex Livingstone Sinclair
No
0
1
3263
Canterbury DHB
Partnership Health (Canterbury)-596721
Sumner Health Centre
Peter Wynn Nicholson
No
0
1
3381
Otago DHB
Otago Southern Region Primary Health Organisation-597004
Dr Visagie's Practice
Fay Young
NO
0
1
Here is my mapping table-
Locum Flag
No count
Yes count
Percentage
No
1
0
1
No
1
1
0.75
Yes
1
1
0.25
No
2
0
0.5
No
3
0
0.3333
No
4
0
0.25
Yes
2
1
0.125
No
2
1
0.75
Yes
0
1
0.75
Yes
0
2
0.375
Yes
0
3
0.25
Yes
0
4
0.1875
I have to add an additional column called 'percentage' in my main table by refering the mapping table.
For ex for a particular practitioner, Locum flag is 'Yes', nocount is 1 and yes count is 1, then percentage should be '0.25'
How should I do this?
So, when you are adding data to your main table, why not just add a chunk of code that would calculate what the percentage would be and keep the mapping table 'on paper' ? (And then store the result)|||hi Tas_CRO
How do I add that chunk of code to my main table?
That is probably I need to know
Thanks
No comments:
Post a Comment