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

XL Reporter Parameters Issue

Hey all,

I have encountered an issue where the syntax that the documentation and even the UI in XL Reporter is telling me to use is incorrect. I'm trying to add a selection for the YTD of the previous year to a parameter that contains a financial period. However, when I try to do this, it tells me that the selection I entered is invalid "The error returned was: Syntax error near: @Per".

Obviously, @Per is my parameter, I don't understand why this wouldn't work. Here is the syntax that I am trying to use:

YTD(@Per-12)

Has anyone encountered this error before?

Thanks,

Kevin

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2008 at 08:27 PM

    Hi Kevin,

    I must admit i've not tried to use the YTD function for a previous year. I don't have SAP on me but I think you could use something like

    Code >= YEARFIRST(@Per - 12)

    And

    Code <= YEARLAST(@Per -12)

    Regards,

    Adrian

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 14, 2008 at 01:10 AM

    Hi,

    Please make sure you have defined a correct parameter. For example it's Date type or others.

    To apply the parameter, click on one column for example, choose Financial Periods from the selection window, enter the syntax as you did YTD(@Per-12), this should be the correct syntax for last year.

    There is also a syntax documentation on the portal. It may help you.

    The patch should be portal> Document Resource Center> XL Reporter, the file is : using syntax and functions in XL Reporter.pdf

    Hope this helps.

    regards,

    maggie an

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Maggie,

      This is actually the problem. I'm using all of the syntax documentation and even the UI to help me develop this formula, and I'm still getting this syntax error.

      After entering the parameter in the dimension lookup, I'm double clicking on the value and it gives me a list of options. The option I want is previous year YTD which it tells me is YTD(@Per-12). However, when I try to enter this, it says "syntax error near: @Per".

      Any ideas?

      Thanks,

      Kevin

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 10:11 PM

    Hey all,

    It had to do with the parameter itself. It was setup as an expression which is obvious after I thought about it. An expression is going to use 200801:200803 instead of just 200801. So you can't do subtraction from that.

    Therefore, I changed my parameter to be two dimension parameters for start and end period. That allows me to use this syntax.

    Thanks,

    Kevin

    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.