% Deviation ?

Wed, 11 May 2016 03:13:26 GMT

HI All,

I am having Data

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

Re: % Deviation ?

settu_periasamy — Wed, 11 May 2016 04:16:58 GMT

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