0
May 29, 2014 at 05:57 AM

# Get the RESULT when the result of a KF used CALCULATION tab

52 Views

Hi guyz,

Just want to ask how can I solve this scenario:

Current Report Output:

Customer Actual Target Status Number of Transactions Percentage

Payer 1 2/5/2014 2/6/2014 1 1 100%

Payer 2 1/15/2014 1/10/2014 0 3 0%

Payer 3 1/22/2014 1/20/2014 0 1 0%

Payer 4 3/8/2014 3/10/2014 1 2 50%

Payer 5 2/11/2014 2/15/2014 1 3 33%

Result 3 10 0%

The figure in RED is the wrong one..How ca I make it calculate so that the result will be 30%?

NOTES:

Status and Percentage are FORMULA...

In the CALCULATIONS tab of STATUS, the CALCULATE RESULT AS is set as TOTAL..

Status = (Actual <= Target) * 1 + 0

Percentage = Status %A Number of Transactions

But this must be the CORRECT OUTPUT:

Customer Actual Target Status Number of Transactions Percentage

Payer 1 2/5/2014 2/6/2014 1 1 100%

Payer 2 1/15/2014 1/10/2014 0 3 0%

Payer 3 1/22/2014 1/20/2014 0 1 0%

Payer 4 3/8/2014 3/10/2014 1 2 50%

Payer 5 2/11/2014 2/15/2014 1 3 33%

Result 3 10 30%

Thanks a lot!

Loed