Text Object

[#1]

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

[swuehl]

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'

)

[Anonymous]

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'

)