Skip to Content
author's profile photo Former Member
Former Member

Dynamic text variables with CALMONTH offset?

Hi,

I have created a query that shows values for all calendar months in the past two years, using an offset based on current calendar month variable. I am using structures and cell referencing to calculate. I need these columns on the report to be labeled with the name of the month the data is reflecting. I tried creating my own text variable, and using the standard text varaibles, but it is not working and just shows the &ZCALMNTH& technical variable name when I run the query. I tried the query using a user entered CALMONTH value, as well as a dynamically generated "current calendar month" variable and neither worked.

Do I need a customer exit for this? Any suggestions as to what I am doing wrong?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 08, 2012 at 02:04 PM

    see this hope it helps

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 08, 2012 at 02:12 PM

    Thanks, but that thread just talks about key and text display.

    I am having trouble with the functionality of text variables when working with a CALMONTH variable.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 08, 2012 at 02:16 PM

    In the variable settings for ZCALMNTH, you need to update the replacement path to direct to the values from the input-ready variable i.e. "current calendar month". This setting will solve your case. I don't think there's a necessity in any point for a customer exit variable in this case.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 08, 2012 at 03:03 PM

    I was able to get the text variable working with only one month value.

    However, I am doing an offset in a structure - so the user enters a calendar month value, then I offset by -1, -2, -3, etc, to get the past months. How can I display the values for these offset months?

    Thanks!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.