How to convert inbound string data into decimal data inthe eDM

Did you try the toDouble,toDecimal or toFloat functions?

Hi ​@SatyanarayanaCh 

You can do this with a small JavaScript helper in the Advanced personalisation:

<%
function formatAmount(str) {
  if (!str) return "";

  // Remove thousands separators from inbound string
  var clean = String(str).replace(/,/g, "");

  // Split integer/decimal parts
  var parts = clean.split(".");
  var intPart = parts[0];
  var decPart = parts.length > 1 ? parts[1] : "";

  // If decimal part is empty or numerically zero -> show as integer only
  if (!decPart || parseInt(decPart, 10) === 0) {
    var nInt = parseInt(intPart, 10);
    if (isNaN(nInt)) return str;
    return nInt.toString().replace(/\B(?=(\d{3})+(?!\d))/g, ",");
  }

  // If decimal part has value -> show with 2 decimals
  var n = parseFloat(clean);
  if (isNaN(n)) return str;
  return n.toFixed(2).replace(/\B(?=(\d{3})+(?!\d))/g, ",");
}

// Example: amountStr coming from inbound transition (targetData / vars / ctx)
var amountStr = vars.inAmount; // adapt this: e.g. targetData.amount or rtEvent.ctx.amount
%>

<%= formatAmount(amountStr) %>

Behavior:

• "432,897.0000" > 432,897
• "432,897.5000" > 432,897.50

Just replace vars.inAmount with your actual inbound field (e.g. targetData.amount or recipient.@amount).