1 Reply Latest reply on Apr 23, 2014 3:38 PM by philmodjunk

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

    Christian

      Title

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

      Post

           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!!