Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I every one;
I need to get the calculate the percentaje of subtotal like % Sales by Country Column
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?
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) )