Weekly Sales Data Report with Rolling Averages

building reports desktopintelligence
1

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.
Capture.PNG

kewellh (BOB member since 2019-05-08)

2

Welcome to B :mrgreen: B!

You may get some help with using the Previous function, this you could use to for a whole raft of what you may need

:wink:

BarkyBaloo (BOB member since 2007-07-04)