Before Function

[tmumaw]

Morning everyone,

Question for you all.  I am using this statement:

Sum({<Wkend = {1}>} Billed) - Before(Sum({<Wkend = {1}>} Billed)) 

What is weird in 2016 I have 433,316 and my before column for 2015 is 918,177......the statement is giving me an answer of (801,327).  Any ideas what I am doing wrong?  I am using it in a pivot table with dimensions of year and week.

Thanks

[sunny_talwar]

Both Year and Week are pivoted? May be you need to add TOTAL

Sum({<Wkend = {1}>} Billed) - Before(TOTAL Sum({<Wkend = {1}>} Billed))

[tmumaw]

Nope

[sunny_talwar]

Can you may be post a sample or an image?

[tmumaw]

[sunny_talwar]

hmmm, its weird.... What if you add this as your expression? Do you see the value from last year?

Before(Sum({<Wkend = {1}>} Billed))

[tmumaw]

Really weird.....

[sunny_talwar]

I have no idea what it might be. Unless you can share a sample, I am out of ideas

[tmumaw · Accepted solution]

Okay my mistake forgot the set analysis piece in the before column

[sunny_talwar]

So it seems to be working now? Right?