Skip to Content
0
Former Member
Sep 26, 2007 at 10:00 PM

Fiscal Year Period User Choice to Restrict the Balance wrt to version

24 Views

Hello friend, I have a Budget Balance key fiegure. which has values for a period say 001.2007 4 Values . sum equal = 13035

Now I want to Create a Current Period Balance in Report and YTD Balance in Report

For Current Period I did this as below but it is not working

<b>

Restricted Key Figure Budget Current period</b>

Budget Balance key fiegure

Restrict with Value Type for Budget Data = 90

Restrict with Fiscal Yr/ Period User Enter Variable say user enter 006.2007

Restrict with Version Type for Budget Data = User Choice say user enter 20

I am still not getting the correct Current Period balance in rep it always take january 2007 balance.

Now same for YTD

Restricted Key Figure Budget Current period</b>

Budget Balance key fiegure

Restrict with Value Type for Budget Data = 90

Restrict with Offset Range January Customer Exit Variable -- Fiscal Yr/ Period User Enter Variable say user enter 006.2007 so it will be 001.2007 --006.2007

Restrict with Version Type for Budget Data = User Choice say user enter 20

I am still not getting the correct YTD Period balance in rep it always take January 2007 balance.

Please help me with the logic to work this CURRENT PERIOD BALANCE AND YTD

iF You have any code you can send me at soniyakv@hotmail.com

Thanks

Soniya