Problem with TMVL function
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!
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.