9 Replies Latest reply: Aug 27, 2014 9:32 AM by Niranjan k RSS

    Expression

    Niranjan k

      Dear Exprerts,

       

      =if(Variance/Num(sum({<Year=>}Budget),'$#,##0')*100>=-0 and Variance/Num(sum({<Year=>}Budget),'$#,##0')*100<=-10,RGB(153,0,0),RGB(147,193,150))

       

      could some one help me im not getting result whats the error

      expression correct,i dont know how to write in between >=-0 and <=-10

      some one guide me

       

      Thanks In Advance

      Niranjan