Graphics In Calculated Field

[Elena]

Datapage type:  Tabular report

Objective:  To show a red flag whenever two calculated fields did not produce the same results.

 

Question:

 

Is it possible to embed a graphic in calcualted field? I issued the following string that when checked for validity gives out a "valid" confirmation. I was very happy.

 

But then when I checked the embedded code on html, it gives "Error in formula". 

 

Below is the code:

 

CASE

    WHEN [@calcfield:3]=[@field:Grade] THEN ''
    
ELSE <img src="https://mysource.com/images/redflag.jpg">

END

 

 

 

All help is appreciated as usual.

 

Best,

Elena

 

 

 

[Jan]

Hello Elena,

 

As far as I know, tags do not work in a Calculated field.

So, I am afraid, Graphic does not work.

 

But you can add you idea to the ideabox and, I hope, this feature will be added.

[cheonsa]

Hello,

You can display the image via HTML Block. 

You may use this formula in the Calculated Field:

CASE

WHEN [@calcfield:3]=[@field:Grade] THEN ''
    
ELSE '<img src="https://mysource.com/images/redflag.jpg">'

END

Then, insert an HTML block and display the result of the calculated field. Render it as an HTML.

 

To hide the calculated value, please see this post: