Unable to Truncate Custom Field-Based Formulas

Hi there,

I have a seemingly easy formula that I cannot get to truncate to two decimals to the right of the decimal (dollar amounts).

Context: EDI  transmission of document custom fields – setup for calculating the correct dynamic totals for transmission on the 810 (Invoice)

I have two fields that are calculating correctly but sometimes go beyond the hundredth cent decima fields causing transmission errors.

I have attempted both rounding up and truncation formulas but unable to get the nesting to work without errors.

Seems simple so what am I missing?

Are their formula limitations for custom fields in Netsuite or is it a matter of TRUNC formatting?

See formulas below that requires truncation to dollar amounts: $xxx.xx

TermsDiscAmount_Calc

({custbody_sps_termsdiscountpercent} x .01) x {subtotal}

TermsDeferredAmountDue
{total}-{custbody7}

NOTE: (format performed due to best results for invoice fields – discount percent is a dynamic % by Trading Partner)

Any help on this would be greatly appreciated!