Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Select statement using mathematical operator on property

Hi,

In EHP7 FOR SAP ERP 6.0, JavaScript engine, I have this select statement to retrieve current year:

*SELECT(%ACT_YEAR%, "YEAR","CATEGORY", "[ID] = 'ACTUAL'")


Now I'd like to create a select statement that uses the Year property for Category Actual to find next year, i.e. something like this (not working):

*SELECT(%ACT_YEAR_1%, "YEAR","CATEGORY", "([ID] = 'ACTUAL') +1 ")

What would be the syntax?

Thanks,

Cecilia

replied

Hi Cecilia,

Sorry, by this is not possible: ([ID] = 'ACTUAL') +1 - only text comparison!


If you want to get a next year, you have to create a new property of CATEGORY dimension like NEXTYEAR and fill it with the required number.


Vadim

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question