Applying a conditional formatting inside out list view will show our number field with fractions .00000000

john john 966 Reputation points
2021-02-03T23:17:52.33+00:00

We have a calculated column of type number and we applied a conditional formatting on this field, but after applying the conditional formatting the field will show .0000000 fractions as follow:-

63684-conf.png

so can we fix this?

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,828 questions
0 comments No comments
{count} votes

Accepted answer
  1. Li Zhang_MSFT 1,566 Reputation points
    2021-02-04T07:50:42.61+00:00

    Hi @john john ,

    Currently this seems to be a known issue. Please click Advanced mode on the bottom of Conditional formatting, find the property "txtContent": "[$FieldName.displayValue]" as shown below:

    63877-displayvalue.png

    Then update the property value from [$FieldName.displayValue] to [$FieldName] or @CurrentField.

    63878-remove-displayvalue.png

    Result for your reference:

    63840-results.png

    ---------------------------------------------------------------------------------------------------------------------------------------------------------------

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.