Forum Discussion

HarveyM's avatar
HarveyM
Helper I
4 years ago
Solved

Conditional Formatting display issue

Hi, I have a data source of 1s and 0s, the data type is whole number. When I apply conditional formatting, the 0s all change to the cross icon, however only a selection of the 1s change to the tick i...
Dashboards
  • HarveyM's avatar
    HarveyM
    4 years ago

    Hi amitchandak This is a whole number, I resolved the issue from switching from sum of the cell to average of the cell. Thank you 

amitchandak's avatar
amitchandak
Super User
4 years ago

HarveyM , Is you number is decimal number, Make sure it is a whole number. This is the first doubt I have.

  • HarveyM's avatar
    HarveyM
    Helper I
    4 years ago

    Hi amitchandak This is a whole number, I resolved the issue from switching from sum of the cell to average of the cell. Thank you