Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have linked my date field with master calendar date field. Now I need to find the missing dates in my data using master calendar date
in an expression.
The expression for actual days is
Count(DISTINCT {<Field name>} DATE) which is giving correct results.
Now I want to find the count of missing dates for each field.
I am not sure what you mean by "missing dates". Your script will populate the calendar with all possible dates between the min and the max dates, so there are no "missing dates" in the normal sense of the phrase.
Missing dates are the ones which has no Field value ie Funds
Then you can adapts Sunny's expression. Something like
Count(Distinct DATE) - Count({<Funds = {'*'}>} Distinct DATE)
please find attachments.
Regards
sahadev
In Help.qvf i have count missing dates
using Following Expression
"count(if(IsNull(Value),Date))"
Its work Fine
Regards
Sahdev