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(none of which work)
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.
*SELECT(%AREGION%, "[ID]", "ACCOUNT","ASIAREGION='Y'")
*IS <> ASREGION