i have a custom script built with an output number. Cant seem to figure out how to include a thousands separator for the answer. I am piping in the answer to a text page. Got the decimal points to work but I have seemingly tried everything on the forums to figure out the comma separator and am stumped!
Example code from script:
%%peracre = sgapiGetValue(51);
%%acres = sgapiGetValue(65);
%%overalldollarslost = (%%acres * %%peracre);
Output calculates great but I want answer to be 123,456
Right now it is 123456
I think that the sgapiNumberFormat function should do this for you. See the documentation for details – https://script.surveygizmo.com/help/sgapinumberformat
Be aware that if you export your results as a CSV file, the comma in the data may be interpreted as a separator.