Alpha Video Training
Results 1 to 7 of 7

Thread: Print positive value for a negative

  1. #1
    Patrick Browne
    Guest

    Default Print positive value for a negative

    I have standard letter which is for customers due a refund, their having overpaid by cheque amounts.

    Does anyone know of a quick and easy way to strip the minus sign from the database value (account balance) and then insert into the letter?

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Print positive value for a negative

    Define a calculated field and place it on the letter rather than the real field.

    expression could be

    abs(realfield)

    -(realfield)

    etc

  3. #3
    "Certified" Alphaholic Tom Henkel's Avatar
    Real Name
    Tom Henkel
    Join Date
    May 2002
    Location
    New Jersey, USA
    Posts
    1,877

    Default RE: Print positive value for a negative

    Create a calculated field in the letter. Use the abs (absolute value) function to make the field value ALWAYS positive.

    amount abs(table.field)

    Then in the letter, print the calculated field "amount".

    Tom

  4. #4
    "Certified" Alphaholic Tom Henkel's Avatar
    Real Name
    Tom Henkel
    Join Date
    May 2002
    Location
    New Jersey, USA
    Posts
    1,877

    Default RE: Print positive value for a negative

    Stan, you're just too quick for me.

  5. #5
    Patrick Browne
    Guest

    Default RE: Print positive value for a negative

    I Thank You!

    Please look forward to more questions as I am learning A5V5 from scratch, and have to get this application done a.s.a.p.

    PB

  6. #6
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default RE: Print positive value for a negative

    Welcome, sorry it took so long to answer your first post. We usually do better than that.

  7. #7
    Member Mike Konoff's Avatar
    Real Name
    Mike Konoff
    Join Date
    Apr 2000
    Location
    Illinois
    Posts
    746

    Default RE: Print positive value for a negative

    Patrick,

    You could also install a calculated field on the form/letter/report such as the following:

    if(account_balance

Similar Threads

  1. positive write up for NetMailer
    By Richard Rabins in forum Alpha Five Version 5
    Replies: 3
    Last Post: 03-27-2003, 07:03 PM
  2. positive NetMailer review in the UK
    By Richard Rabins in forum UK Users
    Replies: 1
    Last Post: 03-27-2003, 07:56 AM
  3. positive write up for NetMailer
    By Richard Rabins in forum Announcements
    Replies: 1
    Last Post: 03-27-2003, 04:04 AM
  4. positive NetMailer review
    By Richard Rabins in forum Alpha Four Version 6 and Prior
    Replies: 0
    Last Post: 03-26-2003, 05:54 AM
  5. Negative Number Instead of Positive Number
    By forskare in forum Alpha Five Version 4
    Replies: 3
    Last Post: 01-02-2002, 09:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •