13 Replies Latest reply on Feb 24, 2010 7:21 AM by kilbot

    Calculation help (easy Im sure just confused)

    kilbot

      Title

      Calculation help (easy Im sure just confused)

      Post

      I'm trying to use a calculation with 2 functions and keep getting an error. I am first trying to divide 2 number and then apply a case statement that will change the color of the text base on one number being grater than another. This is what I have down where am I going wrong? Do I need to place something between the 2 functions?

       

       

      Total_UDBE_Amount / Amount_Contract

       

      Case (Percentage_UDBE ≥ Percentage_UDBE_2nd ;TextColor ( Percentage_UDBE ; RGB ( 144 ; 22 ; 22 ) ) )

       

       

       

       

      Thanks