cancel
Showing results for 
Search instead for 
Did you mean: 

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

Loed
Active Contributor
0 Kudos
93

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member199945
Active Contributor
0 Kudos

Hi,

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

Thanks.

Loed
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

Hi Seshu,

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

Thanks!

Loed

Answers (4)

Answers (4)

0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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

former_member182470
Active Contributor
0 Kudos

Try this:-

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

Loed
Active Contributor
0 Kudos

Not also working mate..

Did you encounter already similar problem?

former_member182470
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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

Loed
Active Contributor
0 Kudos

Hi Suman,

The solution suggested by Seshu worked..


THANKS A LOT for your time..=)

Regards,

Loed

former_member182470
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

That's Ok Loed

Loed
Active Contributor
0 Kudos


Hi guyz, still now working..=(

former_member182470
Active Contributor
0 Kudos

Have you tried my suggestion?

Loed
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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