Forms Designer Forum

Hi,

I have a little problem. I use following script to calculate costs.

//Calculate Consulting
var total = 0;
var rows = fd.relatedItems(4).data('ctx').ListData.Row;
rows.forEach(function(item) {
total += parseFloat(item['Kosten.'])
total_overall += parseFloat(item['Kosten.'])
});
fd.field('Kosten_x0020_Beratungsaufwand_x0').value(Number(total.toFixed(2)).toLocaleString("de-DE", {style: "currency", currency: "EUR"}) + ' €');

The script is okay but two Euro symbols are displayed in the field.

Can you help?

Best wishes
Tom

Hello TWendt,

toLocaleString method adds currency symbol when converting number so there is no need to append the euro symbol.

Many thanks, it works.

Best wishes
Tom