Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i am trying to make an agregtion function-( Sum) on tickets sales. i want to "sum" the sales just when it is the first week (i have a colom with the week number so i want to sum just when the value on this colom =1) and to show it per day on the week..
how can i do it when i write the function SUM(TICKETS----------
TNX
Hi, liavganot,
sum(If(expression of the column=1, Sales))
or
Sum(If(Column(1)=1, Sales))