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