Skip to Content
0
Oct 17, 2011 at 06:31 AM

showing budget or actual column value by checking actual month

15 Views

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.