6 Replies Latest reply: Sep 16, 2014 7:04 PM by Marco Wedel RSS

    Multiply values (instead of SUM)

    Josetxo Amonarriz

      Hello,

       

           In the load script, apart from make the SUM of values of a field, I would like to multiply them.

      Sum(Indice) is perfect to SUM the values grouped by IDField, but, is there any way to have the multiplication of all values of the "Indice" field grouped by IDField?

       

      Table:

      load

             IDField,

             Prod(Indice)

             Sum(Indice) as [Indice Field]

      resident Temp

      Group by IDField;

       

      Thanks!