AnsweredAssumed Answered

Split (divide) Number, and show halves in two fields

Question asked by Christian on Apr 23, 2014
Latest reply on Apr 23, 2014 by philmodjunk


Split (divide) Number, and show halves in two fields


     Hi All!

     I am working on a scholarship budget database where we input student scholarship totals in one field, and would like it, in the Fall Semester and Spring Semester fields to populate the halved amount.

     If I create a calculation field and divide the total amount, it will give only one number. But how do I set my fields up so that when I enter the total scholarship amount in the "Total Award" field, the other two fields are populated automatically with the halved amounts?

     I'm guessing there's more than just a basic calculation involved..

     Thank you!!