5 Replies Latest reply: Jul 9, 2013 8:57 AM by Tobias Morgenroth RSS

    Make a division in loadscript

      Hello,

       

      i've a problem reading data in my table and calculating percent. When i tried this (totalAmount is 8324,76):

       

      LEFT JOIN GROUP_TIMES_COMP:

                LOAD

                tAmount / $(totalAmount) * 100 as percent

                RESIDENT GROUP_TIMES_COMP;

       

      I got new colums named "tAmount / 8324" and "percent". The colum "tAmount / 8324" stores the divided values (tAmount/8324) - but i wanted to get this value multiplied by 100 in the colum "percent".

      The colum "percent" stores always "7600" which seems to be the decimal place of $(totalAmount) multiplied with 100.

       

      I tried anything, but could not resolve this yet. Anyone knows the solution?