Getting NaN in a Google Sheet module but not in set variable

I am using this to get an amount including tax but am not getting a proper number in google sheet.s. When I test it in set variable the number is showing.

{{(round((1 + get(map(34.TxnTaxDetail.TaxLine; “TaxLineDetail.TaxPercent”; “TaxLineDetail.TaxRateRef.value”; 30); 1) / 100) * 116.Amount * 100) / 100)}}

chrome_P4QUF9kkBw
chrome_MBdmzeOXVN

Just for test change the column format in the spreadsheet to plain text

If you receive the value correctly this because its try to get value that bigger than 999 and in the format its contains “,”

2 Likes