Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
sum(if(Quantity>=Seats),Quantity) what am I doing wrong.
I want the chart to sum for only those deals where the Quantity is greater than the variable Seats. I tried it iwth the ,0) at the end and still didn't work.
Change brackets...
SUM( IF(Quantity >= Seats,Quantity))
will the same thing work for summing only those that are maximum date.
I have data by day for ending inventory but I want the chart to only sum the last date's data:
sum (if(Date = Max(Date),Cost)) but it doesn't work
dcpy, you need to use Total for Max() in this case:
sum (if(Date = Max(total Date),Cost))
BR