How to get no of days in quarter

[#1]

Hi,

i want to extract no of days in a quarter. how to do that.

Thanks

Piyush

[jagannalla]

Hi,

networkdays (QuarterStart(date), QuarterEnd(date))

if you want to remove holidays list, add holidays list as third parameter

Eg:

networkdays (QuarterStart(date), QuarterEnd(date), {,holiday-list})

Cheers!!

Jagan

[#3]

Hi,

I have have already created Quarter out of date field. i just want to use no of days in a quarter in expression.i am

using quarter as dimension. so , i just want to show no of days in that particular quarter.

Regards,

Piyush

[jagannalla]

Hi,

Take dimension as Quarter

and Expression as Count (Quarter) or Count (Distinct Date)

Cheers!!

Jagan

[Anonymous]

Jagan Nalla

I guess you mean

count (distinct Date)

[#6]

Working Days,Actual days?

Add a 1 AS Count to your master calendar and sum it?

[#7]

Hello,

Do you need to show numeber of possible days regarding selection or simple number of days in Q?

regards

D

[#8]

Hi,

I have selection on year. i am using quarter as dimension in my table.in expression i have to divide a value by number of days in particular quarter. how to get total no of days in a quarter.

regards,

piyush

[#9]

try:

QuarterEnd([YourDateField])-QuarterStart([YourDateField])

regards

Darek

[swuehl]

If you don't have a calendar with all dates in that quarter as indicated above, you'll just need to create a date in that quarter (if you created your Quarter with an underlying date, just use Quarter), for example for today's quarter:

=ceil(QuarterEnd(today())-QuarterStart(today()))