Forum Discussion

  • I assume by "-ve" you are referring to negative numbers. This is an uncommon shorthand in the US.

    You would use a row colorization formula in the report:

    If( [field] < 0, "red")
  • But I don't want to color the entire row as I have several other numeric fields that may also contain negative number. I only want to color the  negative values. Is that possible?
  • Use a text formula field with some HTML allowed and a formula such as this:

    If( [field] < 0,
      "<span style='background-color: #EA3C53'>" & ToText([field]) & "</span>",
      [field]
    )
    • EstherGrandal_D's avatar
      EstherGrandal_D
      Qrew Cadet
      It works perfect to me, the only you need is to transform the last field in text :

      If( [field] < 0, 
        "<span style='background-color: #EA3C53'>" & ToText([field]) & "</span>",
      ToText ([field])
      )

      Thanks.
  • Then within the summery report is it possible to show the negative numbers in red some how?
  • Using the IF statement doesn't seem to work, as the number (difference) is showing as a positive number. How can I get 8-5 to equal -3 instead of 3?