cancel
Showing results for 
Search instead for 
Did you mean: 

Calcualate Opening Balance in Bex

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (0)