Professional Web Applications Themes

Always Rounding Up - FileMaker

Hello, I'm using: Version: FMP 5 Hardware: MacIntosh G4 System: OS 9.2.2 Any way to make FMP always round up? I am dealing in whole dollars and need to round them up to the nearest thousand. Only solution I saw in this forum involved the Int function, which only works with decimals. Thanks, Barbara...

Sponsored Links
  1. #1

    Default Always Rounding Up

    Hello,

    I'm using:

    Version: FMP 5
    Hardware: MacIntosh G4
    System: OS 9.2.2

    Any way to make FMP always round up? I am dealing in whole dollars
    and need to round them up to the nearest thousand. Only solution I
    saw in this forum involved the Int function, which only works with
    decimals.

    Thanks,

    Barbara
    Sponsored Links
    Barbara Guest

  2. #2

    Default Re: Always Rounding Up

    truncate(Amount, -3) will give you the next lower thousand, to which you
    can add 1000 if the right three digits are >=500

    Barbara wrote:
     

    --
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Howard Schlossberg (818) 883-2846
    FM Pro Solutions Los Angeles, California
    Associate Member, FileMaker Solutions Alliance

    Howard Guest

  3. #3

    Default Re: Always Rounding Up

    Hello,

    If I understand, you want
    1000 for any amount under 1000
    1000 for 1000
    2000 for any amount between 1001 and 2000

    if so, my first idea was:
    (int(number_field / 1000) +1)*1000
    but it fails, because 1000 would give 2000

    so
    Case(
    Int(number/1000) = number/1000; number;
    (Int(number/1000)+1)*1000
    )

    I bet there are more elegant ways, though :)





    ----- Original Message -----
    From: "Barbara" <com>
    Newsgroups: comp.databases.filemaker
    Sent: 10-févr.-04 13:58
    Subject: Always Rounding Up

     
    dollars 
    solution I 
    with 


    Marc-André Guest

  4. #4

    Default Re: Always Rounding Up

    "Barbara" <com> wrote in message
    news:google.com... 

    RoundUP (calculation, number) = Round( YourNumber + 499, -3)


    Glenn Guest

  5. #5

    Default Re: Always Rounding Up

    Hi everybody,

    Yee-HAW, I love solutions, I love Filemaker! I tried Marc's formula
    and it worked like a charm. THAAAAAAANKS!!!!!!!!! :-) Barbara
    Barbara Guest

Similar Threads

  1. rounding
    By GeorgeWS in forum Coldfusion - Advanced Techniques
    Replies: 2
    Last Post: August 10th, 09:05 AM
  2. Rounding off
    By Mike Blezien in forum PERL Beginners
    Replies: 1
    Last Post: November 22nd, 11:22 PM
  3. Rounding Up
    By Brent Bortnick in forum ASP
    Replies: 14
    Last Post: October 8th, 04:19 AM
  4. Rounding problem
    By Roger Godefroy in forum PHP Development
    Replies: 2
    Last Post: August 3rd, 11:01 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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139