Problem with TMVL function

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi,

The problem was with the Fiscal Year Variant only!! There is no space needed after the comma!!

Basically, the solution to this problem is that I added the Fiscal Year Variant as the last argument in the TMVL function!! I however searched the whole documentation but couldnt find anything that stated about this syntax change.

Thanks everybody.

Regards

Sriram

[Former Member · Accepted solution]

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

[Former Member]

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>.

[Former Member]

Hi,

you need to set a space between your komma and 2:

ZFPY2 = TMVL(ZFPY, 2).

D