Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Example:
Cal Week 17
Require Week 16 (ie one week back)(effectively ignoring current week data)
Have static data off spread sheet namely weekly usage
expression = ?
my world = 16 x weekly usage
Problem is = I need ytd sales (actual) up to week 16
Hence I can calculate % penetration into my customer base
ie 16 x 2000 = 32000 vs 25000 = 78%
happy hunting... any ideas...
Please read these two documents:
thanks Gysbert.
This doesnt really answer my question as its a string of text that i cant get right.
the example i have given doesnt require any uploads.
thanks again. im sure i will come right soon.
cheers
I think what Gysbert was suggesting was that your question is phrased in a very abstract manner - it's hard to follow what story you're putting together, and your title doesn't explain what you're after at all - try to include a reference to your actual question.
If your current week is 17 though, you can get your previous week by using Max(Week)-1 - in order to use that within a ytd setting, you'd want to use:
Sum({<Week={'<=$(=Max(Week)-1)'}, Month>}Sales)
As an example. That would sum your sales for all previous weeks up to your max week, but would still be limited by other selections (i.e. year) but is ignoring your month selection to ensure it's ytd and a month selection wouldn't alter it.
As for your last part "ie 16 x 2000 = 32000 vs 25000 = 78%" - no idea what you mean here, sorry!
hi,
ok i will endevour to support what im trying to do a bit better as well as title it better.
i think your answer can assist me.
thanks