Nested aggregates question?
Content
Good Afternoon!
I am trying to put a report together that shows the total spend for each agent. It would normally be a pretty straight forward formula of "sum(to_number(tasks.c$spend))" but, there are two columns of data I need to filter through. One type of spend we have issues an order number, but the others don't, so I can't use a filter on the whole report to pull the data. I can't use nested aggregate functions, otherwise, I would do this: "sum(to_number(tasks.c$spend))-sum(if(tasks.c$spendtype=103,if(tasks.c$ordernumber IS NULL,to_number(tasks.c$spend)))"
Tagged:
0