5 Replies Latest reply: Dec 4, 2014 9:49 AM by Asim Ansari RSS

    Displaying % in a table

      Hi - I am trying to display revenue as a % of total but for some reason the % option is not working for me. This issue seem to only exist in the second column, % Last 3 Month.

       

      Here is the formula that i am using to calculate % last 3 month:

      =SUM({<month_offset={[>=-1<0]}>}price)+SUM({<month_offset={[>=-2<0]}>}price)+SUM({<month_offset={[>=-3<0]}>}price)/1000

       

      12-2-2014 12-31-15 PM.png

      12-2-2014 12-31-58 PM.png

       

      Please help!

       

      Z