3 Replies Latest reply: May 23, 2013 3:34 AM by AlexAnd RSS

    format number not working

    User395957
      Hi,


      we are using the following code to print the supplier name and amount

      <?xdofx:rpad(replace(Payee/Name,' ','')||sum(DocumentPayable/PaymentAmount/Value)||'pONLY',54,'*')?>

      current o/p:
      PAYabccompany130125pONLY*********************

      desired o/p:
      PAYabccompany130125.00pONLY*********************

      but if i use format number here its not working

      <?xdofx:rpad(replace(Payee/Name,' ','')||format-number:sum(DocumentPayable/PaymentAmount/Value);’999999D99’||'pONLY',54,'*')?>


      plz help on this issue