AnsweredAssumed Answered

Simple Calulation

Question asked by peanuts on Nov 5, 2014
Latest reply on Nov 5, 2014 by peanuts


Simple Calulation


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?