Skip to Content
0
Former Member
Jun 09, 2009 at 10:20 AM

How to calculate the percentages

43 Views

Hi Gurus!!

I am having a key figure(say suppose KF1) which had undergone currency conversions in query designer level to USD.

Now i want one more field(KF2) in my report in which i should get the values of percentages based on KF1 and its overall result.

Means i have 1000,2500,3400....under KF1 and the total is 25000. Finally under KF2 i should get as mentioned below

KF1----


>KF2

1000----


>(1000/25000)*100

2500----


>(2500/25000)*100

3400----


>(3400/25000)*100

So like wise i shold get the percentages based on KF1 and its total.

I had tried SUMGT and %GT functions as mentioned below:

kf1/sumgt(kf1) and kf1/%GT(kf1) and for both of them the query is showing errors like you cannot use these functions in the query. correct the query.

Pls suggest me the solution.

Thanks in Advance

Jiten

Edited by: Jitendra Yuddandi on Jun 9, 2009 12:20 PM