Using eval to set token in drilldown does not work

[bowesmana]

I have a row in a table called DMPrice

<set token="dmp">$row.DMPrice$</set>

this works, however, if there is no DMPrice value, then the token ends up being shown as null in another html panel.

So I tried this:

<eval token="dmp">if(isnull('$row.DMPrice$',"N/A",'$row.DMPrice$')</eval>

both with and without the '' round the row var, but all I get in the html panel is $dmp$, which is what I have in the panel, i.e. referring to the token, so clearly it's not being set at all. What I wanted it to be was N/A if it's null, but no joy.

Any ideas?

[rjthibod · Accepted solution]

You have a syntax issue with a missing parenthesis. Try this where you don't use the single quotes and add the closing parenthesis.

<eval token="dmp">if(isnull($row.DMPrice$), &quot;N/A&quot;, $row.DMPrice$)</eval>

[bowesmana]

Sorry for the late response, only managed to revisit this. That worked nicely thanks. I always miss brackets with eval clauses and can never see them.