1 Reply Latest reply: Jun 14, 2016 6:52 PM by PAUL YEO RSS

    Why exchange conversion field must place after close the Bracket ?

    PAUL YEO

      Hi All

       

       

      Below expression workinf fine :-

      Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1)/1000/Rate, SOURCE))

       

       

      Below expression is not working fine :-

      Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},rEVENUE={rEVENUE}>}Amount*1/Rate)/1000, SOURCE))

       

       

      My question why i need to place the Rate after the ) and cannot place before that ?

       

       

      Paul