7 Replies Latest reply: Jan 23, 2014 9:19 AM by Andrea Longhi RSS

    If statement to display arrow indicator

      Hi guys,

       

      I was just wondering if you could help me with this.

       

      I have two variables:  1. Variable1 (current month score)

                                      2. Variable2 (previous month score) , (both in % value)

       

      I wanted to make a monthly comparison trend indicator using green and red arrows (from bundled images) in a text box. If score increases, green arrow pointing up. If score decreases, red arrow pointing down.

       

       

      This is my text box code:

       

      =if(Variable1-Variable2> 0 ,
      'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_s_r.png')

       

       

      BuiltIn/arrow_n_g.png - Green Up arrow

       

      BuiltIn/arrow_s_r.png - Red down arrow

       


      However, I always get a red arrow pointing down no matter what the trend is, even if i interchange values Can you tell me what i am doing wrong?

       

       

       

       

       

      Regards,

       

      Justin