Count "values" of set expression, in range of two values

[data_guru_001]

Hello,

Please see the below expression I have calculated:

=

num(

(sum(Rolling13Sum)*WEEK)

/sum(Rolling13Sum),'##.0')

From this expression, I am trying to create a chart that shows how many values are associated to a categorized range of numbers. The dimension it should be calculated against is PRODUCT.

So, for example

1-6WKS = 876

6-7WKS = 987

8-15WKS = 621

I'm figuring that I would need to use the Count function, but am having difficulty in doing so. 

This is what I am trying:

Count({$<

num(

(sum(Rolling13Sum)*WEEK)

/sum(Rolling13Sum),'##.0')

= {'>1<6'}>} PRODUCT)

This however, will not portray any data. Can I not use a set expression after Count?

Thanks in advance!

[Anil_Babu_Samineni]

Perhaps this?

Count({<PRODUCT={">1<6"}>} Aggr(num((sum(Rolling13Sum)*WEEK)/sum(Rolling13Sum)),'##.0'), Product))

[data_guru_001]

Hi,

Thanks for the response. Unfortunately, it keeps saying there is an "Error in Expression". 

It is highlighting the end: , Product))

I think it is a simple syntax error, but I'm having trouble getting it to read it.

Thanks