AnsweredAssumed Answered

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

Question asked by laura1553 on Mar 11, 2013
Latest reply on Mar 11, 2013 by 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!

Outcomes