Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2011
    Posts
    7

    Unanswered: Calculation question

    Hi Guy,

    How can I multiply 2 values in a calculation field (Width x Height) and then round it to 2 decimal places within the same calcualtion. I know I can create another field an round the result in there, but I would like to do it within the same field.

    Any ideas?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    dunno, as I dont use Filemaker, however I'd suggest you search the help file or do a google search for filemaker functions

    ..or read da manuel
    Find Answers | FileMaker
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2011
    Location
    New Orleans, LA
    Posts
    3
    Try this:

    Round ( Width * Height ; 2 )

    Be sure Width and Heigh fields are set to be Number fields and the Calculation field is set to return a Number value.
    Last edited by Aigaion; 10-15-11 at 11:26.

Posting Permissions

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