Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I am having Data
Division | Subdivision | Plan | Actual | Difference | |
Gen care | Medical | 0 | 6 | 6 | FALSE |
Gen care | Webinars | 0 | 7 | 7 | FALSE |
Gen care | Conferences/ TTT | 1 | 1 | 0 | TRUE |
Gen care | Tution | 4 | 12 | 8 | FALSE |
Gen care | SMEs | 0 | 9 | 9 | FALSE |
Gen care | Young Doctor prg | 0 | 22 | 22 | FALSE |
Gen care | Launch | 4 | 38 | 34 | FALSE |
Gen care | Classes | 0 | 1 | 1 | FALSE |
In this Table i am having 8 records,True & are false based on the Difference of Plan & Actual..
Difference is '0' Means on Time completed---True..
Difference is Value means not on time ------False
Deviation Should get---- (8-1)/8 = 87.5
How can i achiev this ...?
Kindly help me on this..
Regards,
Helen
Try this.
LOAD *,Actual-Plan as Difference,if(Actual-Plan=0,'Yes','No') as IsTimeCompleted;
LOAD * INLINE [
Division, Subdivision, Plan, Actual
Gen care, Medical, 0, 6
Gen care, Webinars, 0, 7
Gen care, Conferences/ TTT, 1, 1
Gen care, Tution, 4, 12
Gen care, SMEs, 0, 9
Gen care, Young Doctor prg, 0, 22
Gen care, Launch, 4, 38
Gen care, Classes, 0, 1
];
Then, in the Textbox, write the below expression
=Num((Count(TOTAL Division)-Count({<IsTimeCompleted={Yes}>}Division))/Count(TOTAL Division),'#,##0.0%')
Try this.
LOAD *,Actual-Plan as Difference,if(Actual-Plan=0,'Yes','No') as IsTimeCompleted;
LOAD * INLINE [
Division, Subdivision, Plan, Actual
Gen care, Medical, 0, 6
Gen care, Webinars, 0, 7
Gen care, Conferences/ TTT, 1, 1
Gen care, Tution, 4, 12
Gen care, SMEs, 0, 9
Gen care, Young Doctor prg, 0, 22
Gen care, Launch, 4, 38
Gen care, Classes, 0, 1
];
Then, in the Textbox, write the below expression
=Num((Count(TOTAL Division)-Count({<IsTimeCompleted={Yes}>}Division))/Count(TOTAL Division),'#,##0.0%')