2 Replies Latest reply: Jun 2, 2016 8:31 AM by Manuel Capella RSS

    Text Object

    Treasure Dlamini

      Good day,

       

      Please help with the below expression, what am trying to achieve here, I want the output to show me a picture of a smile or sad face if the CM amount is less/greater than the PM.

       

      = 'Performance PM vs CM' & NUM(IF((sum({$<Cycle = {$(#vMinCycle)}>} Received) > (sum( {$<Cycle = {$(#vMaxCycle)}>} Received),'qmem://<bundled>/BuiltIn/smiley3_r.png','qmem://<bundled>/BuiltIn/smiley1_g.png')

       

      Many thanks,

      Treasure

        • Re: Text Object
          Stefan Wühl

          I think you need to split your text box into two: One showing the text at the start and one evaluated to the image link (and then you need to change the display option to image):


          = IF(

          sum({$<Cycle = {$(#vMinCycle)}>} Received) > (sum( {$<Cycle = {$(#vMaxCycle)}>}Received),

          'qmem://<bundled>/BuiltIn/smiley3_r.png',

          'qmem://<bundled>/BuiltIn/smiley1_g.png'

          )

          • Re: Text Object
            Manuel Capella

            You have forbidden a parenthesis:

            = IF(

            sum({$<Cycle = {$(#vMinCycle)}>} Received) > sum( {$<Cycle = {$(#vMaxCycle)}>}Received),

            'qmem://<bundled>/BuiltIn/smiley3_r.png',

            'qmem://<bundled>/BuiltIn/smiley1_g.png'

            )