In words, if the RangeSum is above 100000, put in 100000, otherwise do the sum, then do the RangeSum of this. It almost works, the problem is that when the RangeSum is above 100000, it puts in 100000 in for every line of the data, so when I accumulate this i add on too much. I think i somehow need to do this range sum if statement outside the range sum. Im stuck if im honest, any ideas will be greatly appreciated!!!
For the end result, i want a table with month in first column, possibly another dimension in second column (like product), and the capped per claim number cost in the third column.