Portfolio Analyzer problem adding Count to detail area of cross ta

J

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.
 
R

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
 
Top