Skip to Content
author's profile photo
Former Member

Populating text variable of type Customer Exit dynamically

Hi,

I have a report with 3 columns as following.

"Current period", "Previous period" and "Previous period - 1".

The text variable name is "ZQTR_TXT".

My input variable name is "ZALLOC_PRD".

If I enter 200709 as input, I want to see column headings as

2007Q3 2007Q2 2007Q1.

but I am getting 2007Q3 for all 3 columns though I use variable offset to -1 and -2 for other columns.

Could you please throw some light here as I got stuck with this issue quite a long time? I am using BI 7.0 Query Designer.

Thanks in advance,

Hanuma

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 04:54 PM

    are the previous period and previous period-1 offsets of the original variable

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 07:50 PM

    GHR,

    If the variable is by month you need to subtract by -3 to get the previous period instead of by -1 because a quarter is three months. You could also use a variable on quarter instead of month, but then you would enter in 20073 for Quarter 3 and subtract by only -1 to get previous period.

    Cheers,

    Rusty

    Add comment
    10|10000 characters needed characters exceeded