3 Replies Latest reply on Mar 11, 2013 4:17 PM by laura1553

    Sum range of consecutive related fields rather than designate separately in function?

    laura1553

      Title

      Sum range of consecutive related fields rather than designate separately in function?

      Post

           Hi there. I'm new to FM and using Pro 11.  When creating a calculation field, is it possible to designate a range of consecutive related records in a table in the formula rather than designating each separately?  For example:  Sum (field1:field130).  Or do I have to designate each of the 130 fields separately?

           The documentation seems to suggest I must designate each field separately, but with a set of 8 tables and 350 records per (with 5 more sets to go), that's a lot of work!

           Thanks for your help!