showing budget or actual column value by checking actual month

[former_member220449]

Hello,

Let's say we have two columns in report; actual and budget.

In variable entry screen user enters: 5 for fiscper, and 2011 for fiscyear.

The requierement is that, the report shows actual column till 5; and after 5 to 12 it shows budget column.

Is it possible to realize this in Bex?

(I tried to do this with formula variables, but I guess, formula variables takes a fix value, it doesn't change for each month).

Thanks in advance.

[former_member188080]

Hi,

Normally it is shown like that in the report.

You can create two keyfigures

there will be one entry variable (make it single entry mandatory)

actual keyfigure will be showing 1-5 th month

and 2nd RKF budget KF will be showing offset between 12-5

Thanks and regards

[Former Member]

HI

can you tell me actual ans budget are two different keyfigures.

Regards,

Ranganath

[former_member220449]

They are same key figure.

[Former Member]

Hi istanbul,

I thiink it will be chearecteristic,

i'm assuming the version 10 for actual, version 20 for Budget.

1>>> create a user entry variable for fiscper and fisc year

2>>>>create 12 charecteristic value varibles with customer exit for version charecteristic.

for ex: 'ZVER01' ,ZVER02 ....ZVER12.

3>> Create 12 new selections

first new selection:

for ex: drag the KEY FIGURE*for ex: revenue... FROM LEFT TO RIGHT

drag the fiscper and restict with 01

drag the version and restict with 'ZVER01' variable

second new selection:

drag the KEY FIGURE*for ex: revenue... FROM LEFT TO RIGHT

drag the fiscper and restict with 02

drag the version and restict with 'ZVER02' variable

like this create 12 neew selections

goto cmod to write the customer exit :

When  'ZVER01' OR 'ZVER02' ...........'ZVER12'.
DATA: ZLOW(2) TYPE C.

IF I_STEP = 2.

Loop at i_t_var_range into intern_range where VNAM = 'USER ENTRY FISC PER VARIABLE'.
 
ZLOW= intern_range-low.
 
If i_vnam+4(2) > ZLOW.

L_S_RANGE- LOW =  '20'. *budget values*

else 

L_S_RANGE-LOW = '10'.

ENDIF

L_S_RANGE-SIGN = 'I'.
L_S_RANGE-OPT = 'EQ'.

APPEND L_S_RANGE TO E_T_RANGE.
 
ENDLOOP
ENDIF.

Regards,

Ranganath

[Former Member]

Hi,

Create an Restricted Key Fig as " Budget " and Restrict KeyFigure by FisPer by setting offset as variable.

From - FisPer + FisPer Variable(User entered value)

to - FisPer + 12

Regards,

Geeta