RPAS rules: Filter Sales from first sales to certain weeks.
Hi all,
I am trying to select subset of sales data from the first sales to certain number of weeks(lets says 13 weeks).
I have tried the begin and end keyword and this what rules look like and it runs very slow. Is there any other function I can use to filter data as per need.
filterSales= if(sales>0 , dateDiff(begin, end,"WEEK" ) <=13, sales,0)
Any suggestions.
Thanks
Nick