8 Replies Latest reply: May 25, 2016 7:40 AM by PAUL YEO RSS

    why compute Total with field = Rate cannot work ?

    PAUL YEO

      Hi All

       

       

      I have below expression work fine :-

       

       

      Sum( {<eXP={eXP}>} Amount*-1/1000)

       

       

      Below is the expression which i want to compute TOTAL for the above expression , IT Also work fine, as shown in table 1 :-

       

       

      Sum(ALL {<eXP={eXP}>} Amount*-1/1000)

       

       

      Now i have expression below , which convert all the currency to SGD:-

       

       

      Sum( {<eXP={eXP}>} Amount*-1/1000)/Rate

       

       

      when i modify the above expression with compute Total as below :-

       

       

      Sum(ALL {<eXP={eXP}>} Amount*-1/1000)/Rate

       

       

      it cannot work as shown in Table 2.

       

       

      Can some one advise me ?

       

       

      PAul