1 Reply Latest reply: Dec 19, 2014 7:30 PM by Marco Wedel RSS

    Problem Number/Character?

       

      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?