Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

1 Reply
maxgro
MVP
MVP

are you sure the problem is in the second line and not in the first one?

Sum(if(year_ent=year(Today()),  conta_ent, 0) )

/

Sum(TOTAL <week_ent,General_Performance> if(year_ent=year(Today()),  conta_ent, 0) )