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?
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$), "N/A", $row.DMPrice$)</eval>
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$), "N/A", $row.DMPrice$)</eval>
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.