I have a table with this layout
I want a table that only show the sum where num1 is greater than num2. The total would be the sum of that condition. Can this be achieved on any type of table?
sum(aggr(if(sum(Num1-[Num 2])>0,sum(Num1-[Num 2]),0),Id,date))
It almost did the job. this example maybe didn't help a lot, but with a little change to:
sum(num1)-sum(num2) did the trick. thanks!
Retrieving data ...