I have a report where I calculate a prior year and then a current year sold amount. I want to have the titles of these measures equate to another define I created. What is the right syntax to use in the title field to make that work?

YTD Sales: if current_year = 0 then sales_amount else 0

LY Sales: if current_year = 1 then sales_amount else 0

these two get my values.....I then created:

ytd_name: if current_year = 0 then accounting_year

ly_name: if current_year = 0 then accounting_year

These two get me the year name (as 2015, 2014).

How can I put that in the title? I know if I do &with the field name it prompts me to enter a value which then appears, but I don't want that. I just want to have the value appear based on the define.

anyone??

This message has been edited. Last edited by: <Kathryn Henning>,

Andrea,

Do you have access to the Text Editor in InfoAssist? These code creates dynamic titles, and will change as the year changes; however, you won't be able to open the report using the GUI. Thanks

Luiz

Column Current Year:
-SET &CurYR = (DATECVT(EDIT(&YYMD,'9999'),'A4', 'I4') ) ;

Column Last Year:
-SET &LastYR = (DATECVT(EDIT(&YYMD,'9999'),'A4', 'I4') -1) ;

Thanks - I'll try that.

Any other suggestions? unfortunately, when it goes to text, I can't hand it over to a user to maintain. They don't know how to edit via text.