on 06-23-2007 4:51 AM
Hi,
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
Eq
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
Hi,
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
Eq
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......
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.