Data Port Fixed length output decimals

JohnJohn Member Posts: 43
I’m building an output oriented Data Port for a Fixed Length output file.
I want to output a decimal field with 2 fixed decimals and a right alignment.
Nothing spectacular I think, but NAV370 disagrees with mee.
Any hints on this?

Comments

  • Torben_R.Torben_R. Member Posts: 99
    try this
    PADSTR('',13-STRLEN(FORMAT(Amount,0,'<Precision,2:2><Standard Format,0>')),' ') +
    FORMAT(Amount,0,'<Precision,2:2><Standard Format,0>')
    
  • JohnJohn Member Posts: 43
    Tanks, it does the trick.
    Is it a simple solution for a simple problem, Nuh!
Sign In or Register to comment.