I'm trying to calculate the average sales per rep per territory. The number
of reps is a member property. Here is the query

WITH MEMBER [MEASURES].[NB REP] AS [DIM
TERRITOIRE].[TERRITOIRE].CURRENTMEMBER.PROPERTIES("NB REP")


SELECT {[MEASURES].[MONTANT] / [MEASURES].[NB REP]} ON 0,
{[DIM TERRITOIRE].[TERRITOIRE].MEMBERS} ON 1
FROM PHYTOSOURCE

I get the following error message:
Query (4, 8) The function expects a tuple set expression for the 1
argument. A string or numeric expression was used.

I read in bol some stuff but I just can't put my finger on it

thx

Fred