Skip to Content
0
Former Member
Jan 06, 2011 at 11:56 AM

Calculation of number of Days?

30 Views

Hi Experts,

i have two key figures one is calulate the number of day and the other is calulate the total number of stocks.

So now my requirment is the user want to see the data like this,in report level.

for Exp:

if Number of days in between 10 -60 total stock is 100

if Number of days in between 70- 80 total stock is 200

if Number of days in between 81-130 total stock is 500.l ike this.

so how can i achieve this in query designer as i am using BI(7.0)?

Regards,

sat