RANKX including items excluded in the filter

[masplin]

I'm clearly not understanding RANKX fully so maybe someone can tell me what I'm doing wrong. i have a table with following columns

Match Ref Inv Last Mod Date Advert
2 21/4/13 0
2 25/4/13 2
3 26/5/13 5

I want to rank for each Match Ref by Inv Last Mod Date providing the Advert is not blank or 0. I tried

RANKX(FILTER(MatchInput,[Advert]<>blank() &&  [Advert]<>0 && [Match Ref]=EARLIER([Match Ref])),[Inv Last  Mod Date],,1)

However this has assigned a rank of 1 to both the first 2 transactions instead of leaving the first one blank. I thought I was filtering the data so I would have Match Ref = 29 and only the 2nd row. I don't understand how a rank of 1 has been assigned to the first row?

Thanks for any advice

Mike

 

[shg]

Duplicate post