Hi!

I'm looking for help in using the function Count in AS.

I'm tring to count the months of the current fiscal year, but only the one's
that had values in measure named "Sales" in the dimension City named "Lisboa".

When I use the function Count(PeriodsToDate([Time].[Fiscal Year]),
IncludeEmpty) I have all the months of the current fiscal year, including
months that hadn't values (witch I don't want).

But if I replace IncludeEmpty by ExcludeEmpty I have a "Err" in the cell.

How should I use the formula?? Can you help me?

Thank you!
Rodrigo
Lisbon