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

[Loed]

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

[former_member199945 · Accepted solution]

Hi,

Try like this for Actual percentage kfg  change properties put calculate result as : Average , this might work.

Thanks.

[Loed · Accepted solution]

Already tried mate, but it's not working..

I also tried TOTAL and CUMULATED ALONG THE COLUMNS in %Achieved but still no luck..

[former_member199945 · Accepted solution]

Hi,

In advanced tab for that kfg (Actual %)  make sure that use result of this formula  (Default : Standard Value ) need to be selected  ,  put calculate result as average and try .

Thanks.

[Loed · Accepted solution]

Hi Seshu,

May I know what's the explanation behind this? Why did the AVERAGE in calculation tab work?

Thanks!

Loed

[Private_Member_49123]

Hi Loed,

As per my understanding, as you dont have any subtotals calculation involved,you need not have to keep anything under Advanced properties tab of your percentage KF. As it is direct calculation , and rest of your line items are calculated properly, if you just keep "result rows - Always display" at your first field (Customer) in your Query; it should ideally give you proper results.

Thanks,

Shreya J

[Loed]

Hi Shreya,

The Customer field was already set to display always the result that's why I have a result in the last row of the report.

Regards,

Loed

[Loed]

By the way, attached is the TABLE guyz coz the tables in my post is not clear..

[former_member182470]

Try this:-

Perc KF-->Aggregation Tab-->Summation-->Without any ref char

[Loed]

Not also working mate..

Did you encounter already similar problem?

[former_member182470]

We have similar requirement and we handled like that. It works for us..

Just create new Perc KF and apply Summation without ref char.

[Loed]

Hi Suman,

I can't select SUMMATION without any reference character, it gives me an error..How about yours? You did not encounter any error?

Regards,

Loed

[former_member182470]

I think you are trying to de-select ref char to your already existing KF. It won't allow. That's why I have asked you to create a new % KF formula and then choose summation without ref char. This will allow..

[Loed]

Sorry Suman, did not understand it well..I will create a new % KF with same formula in my current % KF and do the AGGREGATION thing?

What will be the difference of the new and existing % KF? Just wondering..Anyway, I will do it..=)

[former_member182470]

That's how it behaves. Please do it to get your desired result.

[Loed]

Hi Suman,

The solution suggested by Seshu worked..

THANKS A LOT for your time..=)

Regards,

Loed

[former_member182470]

If you had tried his suggestion right after his reply, it would have saved your and my time, which led to a long discussion. Anyway, good to know that..

[Loed]

Sorry for that, coz I'm not the one doing this report..I just relay the answers here to my officemate (we are in different locations)..He just told me that the first one worked..

[former_member182470]

That's Ok Loed

[Loed]

Hi guyz, still now working..=(

[former_member182470]

Have you tried my suggestion?

[Loed]

Yes Suman I tried it..I also tried the other USE RESULT OF THIS FORMULA but also not working..

Do you have other idea mate?

[former_member182470]

Hi Loed,

Actually your Perc Formula and Overall Result is intersecting with each other.

You just need to goto Advanced Tab of you Perc Formula KF-->Use Result of Competing Formula

Regards,

Suman