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 ,



      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?