on 03-12-2007 8:44 PM
Hello All,
I have 0Balance and 0Fiscper in my cube. I am creating a BeX report. I need to calculate Opening Balance. The formula for calculating Opening Balance is:
Opening Balance = 0Balance from Previous Fiscal Period
Closing Balance = 0Balance.
Can Someone Please give me the steps on how to do this in BeX.
Appreciate all the help.
Thanks.
Regards,
bw_newbie
Hi,
Create 2 diffrent charectaristic value variable for 0fiscper with single entry mandatory.
take 0balance KF twice and restrict with these variables seperately.when u execute query you have to give 2 fiscal periods according to your requirement.
Hope it will helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.