3 Replies Latest reply: Aug 26, 2011 1:20 AM by Shafvan B

Small questions about Set Analyses - witch we all love so much :-)

Dear all smart people out there,

My report is a financial report, showing 10 weeks at the time, but I only want certain number to show in certain weeks.
(The reason for calculation the week, is that I have divergent weeks/periodes..)

Is it popssible to write something like this:

`SUM({\$<Year={\$(=Year(Today()))},[Week(Today()+(7*4)]= {11,20,28,37,46}>} Sales)`

in order to only get sum if week = 11,20,28,37,46

My problem is the "[Week(Today()+(7*4)]="-part, I dont think I can write it like this.

Any suggestions?

*Still feel like a newbee, still very much in love*

• Small questions about Set Analyses - witch we all love so much :-)

Hi,

is it possible to solve in the load script?

You could set a flag for the weeks you want to display and use that in your set analysis...

Regards

Martin

• Small questions about Set Analyses - witch we all love so much :-)

OMG! Why did I not think of that.. Thank You!!

*like I said - still a Newbee* ;-)

• Small questions about Set Analyses - witch we all love so much :-)

What does "setting a flag for the weeks in the load script" mean??