How to get excluded count of dates on selection of the month

[mohammadkhatimi]

I have list of dates which should be taken as count if the dates is not passed and also the dates are passed.

I want to put this in formula.

For e.g

11/04/2016, 14/04/2016, 15/04/2016,16/04/2015  is the list of dates.

I want two expressions which will count for the dates passed + all the dates in the list as you can see above.

Also my dates are linked to Master Calendar.

sunindia‌

Please help me with this issue..

[mohammadkhatimi]

Please help me with this issue..

Its urgent

[tresesco]

Expected output (mention your additional selections as well, if any)

• When year 2016 is selected
• When no year is selected

?

[mohammadkhatimi]

Passed Dates should be 1 for April 2016...All dates should be 4 as per Holiday Table..

Same for March it should be 4 as Passed dates and All dates.

In simple words, All dates should take count of dates from holiday table.

And passed dates should be based on holiday dates.

[tresesco]

Sorry, not getting your point. What is wrong with the output you get from expression : =Count(DISTINCT {<Year>} D1D) ?

[mohammadkhatimi]

For April its showing as 4. even if I select 2015 year...

It should be 3 for 2015.

[tresesco]

Try creating a year field in the holiday table itself like:

Year(D1D) as HYear

and use this field for user selection.

[mohammadkhatimi]

I cant use this as a selection...I have to use Master calendar's Year & Month..because other things are dependent on Year & Month of Master Calendar.