### Title

No decimal appearing

### Post

I need some help with the following formula. It is not applying decimal where needed. Should be 1000.00

Take a look at attached pic.

"Date: " & $pmtdate & ¶ &

$pmttype & " #" & $pmtnumber & " for " & "$" & Let ( [ N =$pmtamount ;

P = Position ( N ; "." ; 1 ; 1 )

];

Int ( N ) & If ( P ; Left ( Mod ( N ; 1 ) & "0" ; 3 ) ; ".00" )

) & ¶

& "Payment was applied to the Following Invoices:"

"Date: " & $pmtdate & ¶ &

$pmttype & " #" & $pmtnumber & " for " & "$" &

Let ( [ N =$pmtamount ;

P = Position ( N ; "." ; 1 ; 1 )

];

Int ( N ) & If ( P ; Left ( Mod ( N ; 1 ) & "0" ; 3 ) ; ".00" )

) & ¶

& "Payment was applied to the Following Invoices:"

Is there any data formatting specified for this field? Check the data tab on the inspector and make sure that it is specified "as entered".

When I copy and paste

Let ( [ N =$pmtamount ;

P = Position ( N ; "." ; 1 ; 1 )

];

Int ( N ) & If ( P ; Left ( Mod ( N ; 1 ) & "0" ; 3 ) ; ".00" )

Into a data viewer and substitute different values for $pmtamount, I get the correctly formatted value returned so your calculation appears to be correct.