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.
Can you share that file?
Problem is in "TOTALWTAX" field, util.printf format as string. Why not use built in formatting?
i wanted to keep the decimal points down to 2. This was the only was I could figure out how to do it.
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.
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.