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.