Skip to Content
0
Former Member
Apr 28, 2014 at 03:32 PM

Changing a variable value during query runtime

80 Views

Hello All,

Maybe some one could help me with the following request.

I need to display 1) Actual/Budget (XA, YA, ZA): Actual and Budget for January to December depending of the Fiscal year/period entered value. Suppose value entered is 03.2014 then it will display Jan, Feb & Mar of Actual and the rest of the months of Budget. (I did this using 'IF THEN' in a formula and selecting the Actual & Budget from hidden values of the months.

2) Budget (XB, YB, etc.): Need to display only Budget values from Jan to Dec. This is the part I don't know how to figure out. I wonder if a calculated variable can change value during runtime so I can use it to build point 2).

Any hint ?

Thanks in advance,

Angel

. . Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec . . Actual Actual Actual Budget Budget Budget Budget Budget Budget Budget Budget Budget Actual/Budget XA YA ZA WA Finance IT etc Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Budget Finance XB YB ZB WB IT etc Variance Finance XB - XA YB-YA ZB-ZA WB-WA IT etc