Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Below is the code written for counting based on the selection of ActivityType.
Is it right or wrong?
=Count({$<ActivityYear = {2013},
ActivityMonth,
DueDate={"<=$(=Today())>"},
ActivityType={'$(#vActivityType)'},
ActivityWeek>} distinct Count
)
Hey,
Should your distinct clause must not be just before set analysis ? --> Count(Distinct {<....>}Activity Week)