Image is not showing with value

[#1]

Hello everyone,

I created this by using pivot table, i wanted to show green arrow when CY>50% i applied a condition but it is showing the text,

Can any body please help me how to show the image with value

Thanks

[Gysbert_Wassenaar]

The expression can be displayed either as text or as image, not both. If you do need both then you need to use two expressions.

[rido1421]

Hi There

Create two columns one with the text and the other with the image

[#4]

Hello Gysbert,

Thanks for the reply,

I am showing so many values in the single expression only,

Please check my expression below:

=IF(DAY(DATE)>0, if(secondarydimensionality(),

'Revenue:'

&chr(10)&

'CY' & '  '&(Sum(Revenue))&'%'&if((Sum(Revenue))>50,'gmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')&' | '&'LY' & '  '&(Sum(Revenue))&'%'

&chr(10)&

'Sold:'

&chr(10)&

'CY' & '  '&(Sum(Revenue))&'%' &' | '&'LY' & '  '&(Sum(Revenue))&'%'

&chr(10)&

'Growth:'

&chr(10)&

'CY' & '  '&(Sum(Revenue))&'%' &' | '&'LY' & '  '&(Sum(Revenue))&'%' )

,'  ')

Thanks