Skip to Content
avatar image
Former Member

TMVL

Hello Experts,

I have this script which i am running .I am getting an error:

RUN_LOGIC:Member "'2013.09'" not exist

The logic is :

*XDIM_MEMBERSET TIME = TMVL(-12,'%TIME_SET%'),TMVL(-12,'%YEAR%.12'),%TIME_SET%

*XDIM_MEMBERSET ENTITY = %ENTITY_SET%

*XDIM_MEMBERSET RPTCURRENCY = LC

*XDIM_MEMBERSET ACCOUNT = BAS(REVENUE)

*XDIM_MEMBERSET CATEGORY = %CATEGORY_SET%

*XDIM_MEMBERSET AUDITTRAIL = BAS(AuditTotal)

*WHEN TIME

*IS TMVL(-12,'%YEAR%.12'),%TIME_SET%

*WHEN ACCOUNT

*IS BAS(REVENUE)

*REC(EXPRESSION = %VALUE%-[TIME].[TMVL(-12,'%TIME_SET%')],ACCOUNT = S_Rev, TIME = TMVL(1,'%TIME_SET%'))

*ENDWHEN

*ENDWHEN

Your help will be appreaciated.I think its the syntax on TMVL

Regards

Lawrence

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 22, 2015 at 08:38 AM

    Hi Vadim,

    Thanks,i never thought of using a custom measure.

    I have attached a table of data.You will see the formula in the Rolling revenue.

    Thats what i am trying to achieve

    Regards

    Lawrence


    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2015 at 11:03 AM

    Hi Lawrence,

    Use TMVL parameters without quotes...

    TMVL(-12,%TIME_SET%)...

    But in general your script is absolutely strange and incorrect 😔 Can you explain the business requirements? Please, read How To: Ask questions about Script Logic issues

    Vadim

    Add comment
    10|10000 characters needed characters exceeded