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: