Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please help me with this issue..
Please help me with this issue..
Its urgent
Expected output (mention your additional selections as well, if any)
?
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.
Sorry, not getting your point. What is wrong with the output you get from expression : =Count(DISTINCT {<Year>} D1D) ?
For April its showing as 4. even if I select 2015 year...
It should be 3 for 2015.
Try creating a year field in the holiday table itself like:
Year(D1D) as HYear
and use this field for user selection.
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.