Skip to Content
avatar image
Former Member

Problem with TMVL function

Hi,

The following is part of the code in my FOX Formula:

DATA ZFPY TYPE 0FISCPER.

DATA ZFPY2 TYPE 0FISCPER.

ZFPY = VARV(FPY_01).

ZFPY2 = TMVL(ZFPY,2).

When I click on the "Check Formula" button, I get the following error message:

Error : A comma and other arguments were expected instead of )

Info : Syntax error in row 5, column 20.

The same formula doesnt give me an error in another Infor-provider.

I am not able to diagnose the cause for this error! Don't know if the following info is relevant for the problem, but I thought I will give as much info as I can:

The Aggregation level is built on a Multi-provider which contains my planning cube and ICSNAP1 (The Snapshot cube for Stocks - as built based on the relevant How-To Guide).

Help would be greatly appreciated!

Regards

Sriram

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 19, 2007 at 11:26 AM

    Are are you also using 0calmonth in the infoprovider?

    If so, you may have to give the fiscal year variant after the offset.

    Hope this helps you.

    Varadharajan

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      could it be that your fiscal year variant was not defined in the filter? Normally you should not add the fiscal year variant in your function statement.

      D

  • avatar image
    Former Member
    Aug 18, 2007 at 10:33 AM

    Hi Sriram,

    Couple of things to check. Firstly, is the variable FPY_01 a single value variable or a multivalue? In the latter case, VARV wont work.

    Also, which is row 5? If its the statement assigning ZFPY2, try giving a space between <b>,</b> and <b>2</b>.

    Add comment
    10|10000 characters needed characters exceeded