Sorry, the last post was confusing so I am reposting.
Hello, could you please review the following script logic. the issue I am having is I need to multiply with the exchange rate of current month in the REC statement. but the way it is right now, it is multiplying with rate of previsous month. I tried the following(which WONT work)
*DIM TIME=%TIME_SET%
Also, please keep in mind that I cant change *when time is prior to %time_set%, as the actual script logic is lot bigger. thanks.
________________________________________
*LOOKUP RATE
*DIM RATESRC="RATEINPUT"
*DIM INPUTCURRENCY=COMPANY.CURRENCY
*DIM RATE="END"
*ENDLOOKUP
*SELECT(%AREGION%, "ID", "ACCOUNT","ASIAREGION='Y'")
*XDIM_MEMBERSET ACCOUNT=%AREGION%
*XDIM_MEMBERSET CATEGORY=ACTUAL
*XDIM_MEMBERSET DATASRC=ASREGION
*XDIM_ADDMEMBERSET DATASRC=Descendants(DATASRC.TOTAL_GAAP,99,LEAVES)
*XDIM_MEMBERSET RPTCURRENCY=USD,LC
*XDIM_MEMBERSET TIME=%TIME_SET%,PRIOR
*WHEN DATASRC
*IS ASREGION
*WHEN TIME
*IS PRIOR
*WHEN RPTCURRENCY
*IS LC
REC(FACTOR=1LOOKUP,DATASRC=ASREGION,RPTCURRENCY=USD,TIME=NEXT)
*ENDWHEN
*ENDWHEN
*ENDWHEN