% Deviation ?

[#1]

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

[settu_periasamy · Accepted solution]

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%')