Hi All,
I am using BO 4.2, I usually use Excel.
I have this report with weekly sales data, 14 weeks worth. And to the left in the attachment is the Customer Names.
How can I create a variable that returns the average for weeks 2-13.
I then need a “Variance” variable that calculates that average minus this weeks sales.
I also need a variable that identifies any customers that had 0 or <0 (in case of returns) sales in Week 14.
And one more, I need a variable that check the last 4 weeks of data (week 11-14) and checks what the count of sales were - how many weeks in those 4 weeks were there sales.
Any advice appreciated.
kewellh (BOB member since 2019-05-08)
B!