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:
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?