1 Reply Latest reply on May 10, 2018 6:53 AM by Okechukwu Ossai

    Digits after decimal

    suvas.chandra

      I have a formula like this:

       

       

       

      IF [Investment] =1 Then "TVPI=1"

      ELSEIF [Investment] <1 OR ISNULL([Investment]) Then "TVPI<1"

      ELSEIF [Investment] >1 Then "TVPI>1"

      END

       

      This is just a color indicator.

       

      TVPI=1 ----> Black

      TVPI>1----> Green and

      TVPI<1----> Red

       

      And I formatted the field to show two digits after decimal.

       

      But the problem is some of the values which are 1.00 are showing as Green. I looked at the database. I see that the original values are 1.0001. So, I think, it is considering this as greater than (>) 1.

       

      How do I solve this problem ?

        • 1. Re: Digits after decimal
          Okechukwu Ossai

          Try this.

           

          IF ROUND( [Investment],3) =1 Then "TVPI=1"

          ELSEIF ROUND( [Investment],3) <1 OR ISNULL([Investment]) Then "TVPI<1"

          ELSEIF ROUND( [Investment],3) >1 Then "TVPI>1"

          END

          This will convert the values to 3 decimal places 1.000. You can play around with the number of decimal places depending on the precision of your data.

          Hope this helps.

          Ossai