cancel
Showing results for 
Search instead for 
Did you mean: 

Result Calculation

Former Member
0 Kudos
29

In one of our query calculated key figure defined as (X/Y)100 where X and Y are another Key figures. In the result rows of that caluculated key figure is (Sum Of X/Sum Of Y)100. But i can n't get.is there any option to check in properties? . Plz help!!!!!

Thanks in Advance

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

hai

try with formula collision u will get it

regards

hanu

Former Member
0 Kudos

Hi

R u using any structure in ur report?

Thanks

Khaja

Former Member
0 Kudos

Yes. I have tried the option which you have told and it did not solved my purpose.

Plese let me know the possible option.

Thanks

Former Member
0 Kudos

Raghavendra,

On your Formula key figure, right mouse click it and select Properties. In the Formula Collision section change it to Results from this Formula.

Hope that helps,

Regards

Gill

Former Member
0 Kudos

I have tried the option which you told. I want the percentage value based on the result of two KF.

Please give me the possible iptions.

Former Member
0 Kudos

Raghavendra

OK so you are saving that your formula collision is set to Results From this query?

Question, why don't you use the Percentage Share function in the Formula dialogue box rather than dividing it by 100. (This should have no impact on your over total)

Regards

Gill