image in expression?

[#1]

Hi Experts,

I am getting not getting the expected output from the below expression:

=if((vCurrentYearSales-vPreviousYearSales)>0, Num((vCurrentYearSales-vPreviousYearSales)/100,'###.00% qmem://<bundled>/BuiltIn/thumb2.png'), Num((vCurrentYearSales-vPreviousYearSales)/100, '- ###.00% qmem://<bundled>/BuiltIn/thumb1.png'))

I have selected the representation as Image in the General tab of the text box.

I get the output as below.

How do I resolve this issue?

Thanks.

[Gysbert_Wassenaar · Accepted solution]

Use two text boxes. One text box can have only one representation, either text or image, never both at the same time. So put the text box with the image on top of the one with the text. Just make the one with the text large enough so the text will be visible above the image.

[spividori]

HI.

You should make an expression for the % and another expression for the image

I do not know if you can do what you want.

Regards.

[marcus_sommer]

Your link to the picture couldn't be inside a formatting-function - try it with a concat like this:

if(condition, expression-result1 & picture1, expression-result2 & picture2)

- Marcus

[#5]

Thank you guys. Got it resolved..