This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

image.png

Hello,

I am are rendering an xml template as PDF using suitlet
I tried to customize the number format of a variable in the XML free marker template, but it is still printing as an empty value.

*Suitelet data* 
data.section1   = [{"label":"label","value":15217.5},{"label":"label","value":1777024.5},{"label":"label","value":116.7750616067028},{"label":"label","value":0},{"label":"label","value":"30.3641%"},{"label":"label","value":539576.6626},{"label":"label","value":35.457641701987846}]	

*xml template* 
     &lt;#list data.section1  as scenarios&gt;
         &lt;tr class="comforta" line-height="12"&gt;
            &lt;td class="lineTable" colspan="6" align="left"&gt;${scenarios.label}&lt;/td&gt;
            &lt;td class="lineTable" align="left" colspan="12"&gt; &lt;/td&gt;
            &lt;td class="lineTable columnColor" align="right" colspan="4"&gt;${scenarios.value?string(",##0.00")} &lt;/td&gt;
         &lt;/tr&gt;
         &lt;/#list&gt;

The numbers are printing as expected using ${scenarios.value}

Appreciate help!

how do you pass the json data into the pdf template in your suitelet?