Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Would really value if someone can help me with this set. When I mark the year (fieldname Year) and month (fieldname Month) I get the result as in the first picture. What I want is a set-expression that distinct count the ID-field but only the ones that are releated to Enddate. In the lower pic I have manually marked the enddate in that way I would like the set to do.
/Thanks!
Hi,
Try this expression
=Count({<EndDate=P(EndDate)>} DISTINCT ID)
Hope this helps you. Can you attach the sample file.
Regards,
Jagan.
Hi,
Try this expression
=Count({<EndDate=P(EndDate)>} DISTINCT ID)
Hope this helps you. Can you attach the sample file.
Regards,
Jagan.
Thanks. I´d also tried this,
=Count(({$<Enddate=P({1<ID={">1"}>}Enddate)>}ID)
It gave me the same result as yours but aint as nice as yours and can´t hold Distinct.
Hi,
Try something like this
=Count({<EndDate={$(=Chr(39)&Concat(Distinct EndDate ,Chr(39) & ',' & Chr(39)) & Chr(39))}>} DISTINCT ID)
Celambarasan
Hi Celambarasan, thanks. That also works. What does the (=Chr(39)&Concat(Distinct EndDate ,Chr(39) & ',' & Chr(39)) & Chr(39) means?
Hi,
It just replaces the selected date in single quotes like
{'2011-12-30','2011-12-31'}
Chr(39) is single quotes(')
Celambarasan