2 Replies Latest reply on Nov 5, 2014 7:13 PM by peanuts

    Simple Calulation

    peanuts

      Title

      Simple Calulation

      Post

      I am trying FileMaker Pro again to do Monthly Bills-listing the Due Dates, Payment Dates and Balances from each bill. When I first create a NEW table in FileMaker Pro by importing the Xcel file, my Balance Column shows correctly: it's the difference of the Amount Due - Amount Paid. But when I try to change that field in FileMaker Pro from a NUMBER to a CALCULATION such as: "Balance = ( Amount Due ) - ( Amount Paid )" the result shows all the numbers in the Balance Column WITHOUT the "$" Dollar sign. In other words when I imported the file the Balance column showed correctly but afterwards it only showed the result without the dollar symbol. What did I do wrong?

      screenshot_165.jpg