Skip to Content
0
Former Member
Jul 09, 2012 at 02:45 PM

Calculation of Result Row

18 Views

HI All,

We are in the process of building a Report. We have three Key Figures - KF1, KF2 and KF3. There is an requirement where we have to create a formula (KF4). Formula is as below:

KF4 = 100 + ((KF2 - KF1) / KF1) * 100

But the client needs the Result row for KF4 to be calculated differently. Below is the formula:

KF4(Result Row) = Sum of All records( KF2 * KF3) / Sum of all records (KF3)

Please suggest if we can calculate the Result row differently as above.

Regards,

Ranjan