Skip to Content
0
Former Member
May 02, 2007 at 08:43 PM

Week calculation

9 Views

Gurus,

Here is my requirement......

I have actuals and Open orders as key figures in my query.....lets say if user runs the query in 2nd week of 10th period then it has to display

w1 w2 w3 w4

Open orders Actuals+ <=open orders for W2 Open Orders Open Orders

w5

Open Orders

In other words when ever User runs the report then for that week it should add actuals + <=Open orders for the week User runs the report and for remaining weeks it should be open orders.

Can any one explain me how to achieve this in the Query?

Will be awarder good points...

Thanks in advance