This content has been marked as final. Show 4 replies
Pls mark as correct
Any chance you would know a formula that would pull in only dates over 30 days old.
I use sales data and want all sales that were created over 30 days ago.
Did you try this?
it has to be
30 days ago sales = total sales - sales for last 30 days
or logical column could be
case when sales_date < (SQL-___days, -30, current_date) then Sales else 0 end