Conditional Number Formatting

  • 26 June 2024
  • 2 replies

Looking to toggle between whole $ numbers and %’s for budget driver values - I would like to be able to set up any value between 0 and 1 to show up as e.g. 5% vs 0.05, but the same metric also has $20,0000 type direct annual input amounts. Is this possible?

2 replies

Badge +1

It doesn’t seem to be possible within a conditional format to apply number modifier. It would be better to split these numbers in two different metrics, so you can use the default metric formatting and don’t have to apply number formatting in the table itself.

Userlevel 5
Badge +8

As Oliver advised, this is not currently possible in Pigment. I’d suggest raising an idea for now and using the split metric idea that Oliver suggested.