Skip to Content

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

Select statement using mathematical operator on property


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


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):


What would be the syntax?




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.


1 View this answer in context

Helpful Answer

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