Compute Variable KPIs

[tracycrown]

Dear all

I have no problem to load data in Table 1 but do not know how to compute variable KPIs in Table 2.

My expected answer is stated in the attached worksheet :

Variable KPIs

1. Labour Cost per Total Employee.

2. Labour Cost per Full Time Employee

3. Labour Cost per Part Time Employee

Thank you so much

Tracy

[tresesco · Accepted solution]

Like attached qvw?

Dimension: Year

Then pull across dimension to columns(right->top) and then expression to rows(left->down). And yes expression would be better with set analysis rather than IF (i have shown for first expression).

[ashfaq_haseeb]

Hi,

May be like this.

Make sure you have proper Calculation.

Regards

ASHFAQ

[tracycrown]

Der Tresesco

Many thanks for your help, the answer is correct.

IF is not the better method, then can you show me an example on what you described in your advice.

Also if possible, can you also explain or give example on using the following method:

set vLabHC = '($(vLabCost))/($(vHC))';

Set vHC = 'Employee';

Set vLabCost = '[Labour Cost]';

Many Thanks

Tracy