In this sample below... I am trying to create 2 new variables...
Count and CountPending
the count is a new column that is created that is the sum of the seats requested where ticketstatusid=1
the countpending is a new column where the seats requested does not equal 1.
the counts are working and a new collection is created but the value for variable name count is associated with the values for the countpending filter and vice versa.
I thought the syntax was addcolumns(table, col1, formula, col2, formula)
ClearCollect(TicketRequestCounts,DropColumns(AddColumns(GroupBy('Ticket Request',"EventId","GroupedItems"),"Count",Sum(Filter(GroupedItems,TicketStatusId=1),'Seats Requested'),"CountPending",Sum(Filter(GroupedItems,TicketStatusId <> 1),'Seats Requested')),"GroupedItems"));
I'm sure this is something obvious but I'm pretty cross eyed at this point....any thoughts?
If anyone has any ideas for improving the formula let me know please.
