1 Reply Latest reply: May 14, 2013 5:49 AM by Gysbert Wassenaar RSS

    Expression Query

    Sukhwant Matharoo

      hi all,

       

      i have a straight table output:

       

      region          VALUE          % Region

      AMER               10               =10/80 ie 13%

      ASIA                   20              =20/80 ie 25%

      EMEA               50               =50/80 ie 63%

      Total               80                    100%

       

      % Region is desired column results i want but when use Sum formula in expression it takes values as below:

      =10/10

      =20/20

      =50/50

       

      please advise how to use sum function or aggregation function and what is the syntax

       

      thanks