Forum Discussion

Wilk89's avatar
Wilk89
Frequent Visitor
2 years ago
Solved

How to color values ,00

Hi,

Is it possible to color values ​​with a note that does not contain ,00?

Need Help

5 Replies

  • _AAndrade's avatar
    _AAndrade
    Icon for Resident Rockstar rankResident Rockstar
    2 years ago

    Hi,

    Use this formula and put in a conditional formating:

    Color = IF( MOD([SumValue],1)=0,"RED")


    The final result should be this:

     

    • Wilk89's avatar
      Wilk89
      Frequent Visitor
      2 years ago

      I tried but I get an error on my database.

      • _AAndrade's avatar
        _AAndrade
        Icon for Resident Rockstar rankResident Rockstar
        2 years ago

        This error indicates that the measurement has an incorrect data type. Choose format as Decimal Number.

    • Wilk89's avatar
      Wilk89
      Frequent Visitor
      2 years ago

      I tried but I get an error on my database.