Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'
)
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'
)