Responsys V6 Function to Format Number with Thousands Separators
The following function used in Responsys V5 and Responsys V6 Classic does not work in the Responsys V6 new campaign designer. Does anyone know of an equivalent V6 RPL function for the following?
$numberformat(lookup(DistributionListColumnName),8.0f,1,0,en)$
What this is doing in V5 and V6 classic, is inserting a comma as the thousands separator. I believe the variable field must be setup as a 'Number' or 'Integer' field in order for this to work.
For example, if the distribution list column you're interested in contains the value '55000', it will show up as '55,000' when populated in the email.
0