Rangesum Issue

[#1]

Attached you will find this Straight Table. What I am trying to do is that I have Claim No and Occurence No. Claims are tied together by the Occurence No. For Example Occurence NO  1808 has  several Claim No's.

I need all the distinct Count of Occurence No's where Sum(NET_INDEMNITY_PAID)  of all Same Occurence Nos is Less than 1000000 and greater than 0.

I tried using the Range Sum Function Grouping by [Occurence No] as Follows but not the result I wanted.

Rangesum(if(Aggr(Sum(NET_INDEMNITY_PAID),[Occurence No])>0 and Aggr(Sum(NET_INDEMNITY_PAID),[Occurence No])<1000000,

Count(DISTINCT [Occurence No]),0),0,NoOfRows())

Any help is appreciated

[#2]

I also need to add the MAx Year to the statement and I am using the ValueList Dimension, is taht gonna work with it