Dynamic text

hatra

<p>Hi All, </p>
<p>I am trying to use Dynamic text to present a total of column with a label ie "Total expenses row[columnName] " where row[columnName] with  2 decimal places, I have tried but failed , I thnk I may have syntax wrong, </p>
<p>thanks for your help</p>

Matthew L.

<p>Try using the following in your Dynamic Text element:</p>
<pre class="_prettyXprint _lang-js">
"Total expenses " + Formatter.format(row["columnName"], "$###,##0.00")
</pre>
<p>This will prepend the text "Total expenses " along with formatting the row["columName"] to currency with 2 decimal places (you can adjust formatting as needed).</p>
<p>Example attached.</p>