simple calculation gives NaN result if the total is over 1000

[Kevin254478135tb1]

I have a simple calculation in the BALANCE field:
TOTALWTAX - DEPOSIT

the user enters the deposit amount and the balance is shown. However, this is only working if the total balance is under 1000. Over 1000 and I get NaN.

any thoughts on that?

thanks in advance.

[Asim123]

Can you share that file?

[Kevin254478135tb1]

sure...

[Nesa Nurani]

Problem is in "TOTALWTAX" field, util.printf format as string. Why not use built in formatting?

[Kevin254478135tb1]

i wanted to keep the decimal points down to 2. This was the only was I could figure out how to do it.

[Nesa Nurani · Accepted solution]

Go to that field properties → 'Format' tab and select 'Number' there you can select number of decimals and currency sign if needed. Don't forget to remove util.printf from script if you use built in formatting.

[Kevin254478135tb1]

Thank You! I knew there was an easy way to do it, but all my searches eneded up showing complex answers!

All is good now.