All, I'm hoping to get some help with conditional coloring a running total. I have the following expression:
RangeSum (above(sum(Sales),0,RowNo()))/sum(total Sales) - this generates a great cumulative % total. No problems here.
Next, I wanted to color the values in this column red if they were less than 80%, highlighting those that made up the 80% group worthy of focus. I put the following in the background text color box but no luck.