Problem Number/Character?

[#1]

I Have defined

weekNrSysDate='02';

i have a query where column is:

to_char(datecolumn,'iw') as BWeeknr

THEN i have

Expression:

=Sum( {<BMIYEAR={"$(Yearcompare)"},BMIWEEKNR={"$(WeekNrSysDate)"}>} SALES)

yearcompare is character value

but when i now define

WeekNrSysDate=0;

and query:

to_number(to_char(datecolumn,'iw')) as BWeeknr

my expression won't work?

i don't know why?

[MarcoWedel]

please provide sample app

thanks

regards

Marco