4 Replies Latest reply: Jul 22, 2015 2:04 PM by Massimo Grossi RSS

    Calculate Percentage in load script(Resident Load)

      Hello Dears

      I want Calculate percent the following file  Calculate Percentage in load script(Resident Load)

       

       

      ---------------------------------------------

      Populations:

      Load *, Num(  Population) as pop;

      LOAD [% of world population],

           country,

           Date,

           Population,

           Rank,

           Source

      FROM

      TB01_20150721_222616.xls

      (biff, embedded labels, table is [Sheet1$]);

       

       

      [Calculate Percentage]:

      Load

      country,

      Population / Sum( Population )  as [Percentage]

      resident Populations

      Group by country;

       

      ---------------------------------------------

      But Get Erros :Invalid expression