Portfolio Analyzer problem adding Count to detail area of cross ta

[Jeff I]

I am trying to create a Portfolio Analyzer View but when I add the Count
field from the Totals list I get the following error:
The query could not be processed: o Formula error - syntax error - token
is not valid: " Count([Resource List].[Resource Name]^)^ "

The other totals fields work fine.
Any help is appreciated.

 

[Russ]

Hi Jeff,

Try wrapping curely brackets within the ( ... ) pair.... ({ .... })

Sometimes the MDX call wants to process a return set instead of a
simple measure.

Also, let me know if you figure out how to get the counter to
accumulate in the totals row/column....

Russ

 

[Jeff I]

Thanks but that didn't help.