How to break a tie in ranking duplicates

I have a column called [Oil] and I would like to calculated rank column that ranks [Oil] from large to small value.  My current expression for this calculated column is:  

Rank([OIL],"desc",[PROPNUM])

However, some of my wells aka PROPNUMs, have same values on different date, and thus get same ranking.  This is an issue when I sum [Oil] to lets same 30 day, 60 day, 90 day.......because of "multi-dipping" if I use a if statement Rank column with a less than # day criteria.  I don't want to remove duplicates, I'm looking for a solution to break the ties such as if there are ties then break ranking tie by date.  In excel you can use a rank and then countif formula but not sure how to do this in Spotfire.  Any ideas?

Attachments

AttachmentSize
PDF icon 2016-02-11_13-08-41.pdf119.29 KB

(1) Answer

Login