1 Reply Latest reply: Jan 27, 2014 2:09 PM by Massimo Grossi RSS

    calculate the percentaje of subtotal

      I every one;

      I need to get the calculate the percentaje of subtotal like % Sales by Country Column

      percentaje.png

       

      My problem is that I have the condition IF,  where I used the function TOTAL I need your help to put the correct scripting

       

       

      this is my formula:

      % Percentaje =

      (if(year_ent=year(today()),conta_ent,0))/
      Sum(TOTAL <week_ent,General_Performance > if(year_ent=year(today()),conta_ent,0) )   <--the problem is here in the second line is incorrect the syntaxes can you tell me please?