I have a Column definition that is supposed to look at the total sales in the row definition to create the % columns. All my calculations are correct, however, the first % next to current period keeps showing up as a - when it should be + and vise versa. Even if I use the check opposite sign for that column, it ignores that functionality. Any thoughts on why?
Column def: