Skip to Content
Former Member
Jun 23, 2007 at 03:51 AM

Restricted KF and Result Rows



I have Key Figure "Balance".

It is to be taken for Current and Previous Year thus I have restricted it with Year and then with Year-1


Kf1 = Balance

Kf2= Kf1 restricted with Current Year

Kf3= Kf1 restricted with Current Year -1

Kf4 = Kf2/Kf3.

The problem is with the result rows where the results are strange.

It is taking the values which are restricted.

Suppose Kf2 had 3 values but with the Current Year restriction we are taking only 2 values but the third value also comes for the Result Row.

Kf1 Kf2 Kf3 Kf4

2 2 0 #

3 3 0 #

5 # 5 0

10 10 10 1 Result Row....

I would like to know how to make the restricted values as zero so that it doesnot appear if we do any SUMCT/SUMGT function......

Message was edited by:

hemant k