AnsweredAssumed Answered

No decimal appearing

Question asked by projay on May 29, 2012
Latest reply on Jun 2, 2012 by projay

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:"

no_decimal2.jpg

Outcomes