Jump to content

Recommended Posts

I have 3 fields and the first field is Amount the second field is Deposit and the third field is Balance.

Generally my calculation should be Balance = Amount - Deposit

If i insert the Amount, example $100 and the Balance automatically changed to $100.

I need the Balance remain empty unless i insert a number in the Deposit Field.

In my outstanding due report, if their is no Deposit, the Balance field should remain empty.

Any help.

Share this post

Link to post
Share on other sites

comment you are the best:)

Your solution worked fine.

Thanks a lot.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Similar Content

    • By Richard Carlton
      FileMaker Coaches' Corner-Tip 8-Converting from fp7 to fmp12-FileMaker-FileMaker Experts
      Download the free PDFs to see FileMaker’s documentation: http://bit.ly/2nSg7BM
      Get up to speed with the FileMaker Pro 16 Video Training Course! 
      Top Rated Course by FileMaker Expert, Richard Carlton.  
      Experience Richard's dynamic and exciting teaching format, while learning both basic, intermediate, and advanced FileMaker development skills. With 27 years of FileMaker experience and a long time speaker at FileMaker's Developer Conference ,Richard will teach you all the ins and outs of building FileMaker Solutions.  The course is 50 hours of video content!
      Richard has been involved with the FileMaker platform since 1990 and has grown RCC into one of the largest top tier FileMaker consultancies worldwide. 
      Richard works closely with RCC's staff: a team of 28 FileMaker 
      developers and supporting web designers. He has offices in California, Nevada, and Texas.

      Richard has been a frequent speaker at the FileMaker Developers Conference on a variety of topics involving 
      FileMaker for Startups and Entrepreneurs, and client server integration.

      Richard is the Product Manager for FM Starting Point, the popular and most downloaded free FileMaker CRM Starter Solution.

      Richard won 2015 Excellence Award from FileMaker Inc (Apple Inc) for outstanding video and product creation, leading to business development.

      RCC and LearningFileMaker.com are headquartered in Santa Clara, CA.

      Please feel free to contact us at support@rcconsulting.com
      If you want to explore building I.O.S apps for I Phone or I Pad and deploying those out to the Apple App Store.
      Here is a video introduction to our iOS App Training https://www.youtube.com/watch?v=cVxQe_yAshw
      Looking for FM Starting Point free software download: http://www.fmstartingpoint.com
      For More Free FileMaker Videos Check out Http://www.filemakerfree.com
      Visit http://www.learningfilemaker.com for all facets of FileMaker Award Winning Video Training.
      Please Visit Our Channel: https://www.youtube.com/user/FileMakerVideos Please Subscribe While There.

      Please Comment, Like & Share All of Our Videos.

      Feel Free to Embed any of Our Videos on Your Blog or Website.
      Follow Us on Your Favorite Social Media

      Filemaker Pro 16 Training Videos
      FileMaker 16 Videos
      Filemaker Pro 16 Video Course
    • By Kishan_Canoo
      I have a car rental solution and for rental of short term one to two weeks i just need to create a new record one by one which will appeared in my calender View layout via Portal.
      In case, the customer decided to take the car for one year, i can't create 365 new records, It their any possibility to create 365 records automatically by selecting Start Date to End Date?
      Thank you.
    • By jduncan71
      Hello All,

      Recently, my company installed FM server 15 after much begging. The database that my group uses (built in FM12)is hosted on a laptop (running FM12) and I'd like to upload it to the server using FM . I cannot figure out how do do it; there is no "Upload to Server" option, and I'd rather not do it manually. If anyone has some guidance, I'd really appreciate it...
    • By Kishan_Canoo
      In an existing solution one of my client my client has requested to add a field name ‘Item Movement’ (e.g. Best-seller, Fast, slow) and this should be based on a formula per product item and linked to 'Stock re-order level’ field.
      For example, if product A reaches ‘Stock re-order level’ in less than one month, it is categorized as ‘Best Seller'’. If Product A reaches ‘Stock re-order level’ in 2 months, it is categorized as ‘Fast’. If Product A reaches ‘Stock re-order level’ after more than 2 months, it is deemed ‘slow’
      Since it’s depend on a date, I found it a bit complicated. Any help will be most welcome.
      I have attached my solution and i have the following problem.
      When i create a new product the Item Movement set to Best Seller and it should be a New Product instead.
      Secondly, the Item Movement status doesn't change when the date is being changed within the set value.
      If a product was in best seller and the is no more available will the status remain the same?
      Thanks for your help.
      Flexi V3.0.fmp12
    • By Kishan_Canoo
      I have a field, ‘CRM Category’ (I.e. Diamond, Gold, Silver) for B2C End Customer – and another field for Total purchase over last 3 months – Calculation - If customer purchases for Rs 10,000 over last three months, a Diamond Customer, If customer purchases Rs5,000 over last three months, Gold customer. If customer purchases less than Rs5, 000, silver customer
      My question is for the calculation of the Gold customer as for the Diamond i will use the grater symbol and for Silver the less symbol.
      Case ( Total_Revenue  < "$10,000" ; "Diamond")
      Thank for your help
  • Who Viewed the Topic

    9 members have viewed this topic:
    ryan360Works  sh2658  Warren  Joshua Rivers  amallison  Lee Smith  Lola  Christian Chojnacki  Tim Anderson 

Important Information

By using this site, you agree to our Terms of Use.