When you have a formula which is applied to data aggregated using in-view aggregation, the formula can sometimes introduce data values not present in the underlying data. This means you are unable to customise value colouring, for example.

One solution might be to allow custom persistent values to be added to the "Value colour/order/shapes" dialog for a given field?