Hi BO experts
I have a crosstab of time series data for which I would like to calculate % Y/Y.
There are filters on my table, so I am only looking at 12 consecutive quarters.
My calculation [ sum ( sales) / previous ( sum (sales) ; -4) -1 ] fails for the first 4 quarters of the table.
Has anyone come across such a problem before and has a work around?
dav1b (BOB member since 2015-10-01)
Are you saying that you have data earlier than the first date?
Also, is date the only filter criteria for the crosstab?
If so, you might be able to wrap your formula inside a NoFilter() to get the first four.
Thanks, Mark for your reply.
I don’t believe NoFilter works the with Previous function, unfortunately.
And yes, I have maybe thirty quarters in my crosstab and use filters to display 12 of them… Then my Y/Ys disappear for the first four quarters, as the relevant compares are being filtered out!
dav1b (BOB member since 2015-10-01)
Just to be clear, what version of BO are you on? You’ve posted in Desktop Intelligence, so I’m assuming XI3.1 Deski
I’m not 100% certain (do you know how I may check?), but I believe I am on BO 4.2.
dav1b (BOB member since 2015-10-01)