Select statement using mathematical operator on property
*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?