ThomaStudios Posted June 26, 2015 Share Posted June 26, 2015 Now don't jump all over me for using repeating fields. I have done this in other FM tables but I've got a new one where it just isn't working. I have an itemization list and cost in separate repeating fields, 10 reps. I've done this before where I create a calculation field get the the Sum of the cost field. Sum(ItemizationCost). But in this new table it's not getting anything past the first iteration of the field. I've tried various other scenarios all to no avail. Everything is in the same table. Any suggestions? Link to comment Share on other sites More sharing options...
eos Posted June 26, 2015 Share Posted June 26, 2015 Any suggestions? Don't use repeating fields. Link to comment Share on other sites More sharing options...
comment Posted June 26, 2015 Share Posted June 26, 2015 (edited) a calculation field get the the Sum of the cost field. Sum(ItemizationCost). If ItemizationCost is a Number field (or a Calculation field with the result type set to Number), then Sum ( ItemizationCost ) should return the sum of all repetitions of ItemizationCost. This is assuming both fields are defined in the same table, and that you expect to see the sum of all repetitions in a single record. Edited June 26, 2015 by comment Link to comment Share on other sites More sharing options...
ThomaStudios Posted June 26, 2015 Author Share Posted June 26, 2015 That's exactly what I thought, but it's not happening. The calculation is only returning the value in the first repeating field. If I delete that first value and leave the rest, the calc returns nothing. Don't use repeating fields. Really!?!? Like I needed that. You're a big help. Link to comment Share on other sites More sharing options...
Raybaudi Posted June 26, 2015 Share Posted June 26, 2015 "where I create a calculation field " Isn't that a repeating number field with option to auto-enter a calculation, instead? Link to comment Share on other sites More sharing options...
bruceR Posted June 26, 2015 Share Posted June 26, 2015 (edited) Your description of the fields can't be accurate. SumReps.fmp12.zip Edited June 26, 2015 by BruceR Link to comment Share on other sites More sharing options...
ThomaStudios Posted June 27, 2015 Author Share Posted June 27, 2015 BruceR and Raybaudi, You both could be right. Perhaps I was zoned out when starting this; who knows. I ended up deleting the 3 fields in question and starting over again. Now it's all working as expected. Go figure. Thanks for your direction, it helped more than you know. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3221 days old. Please don't post here. Open a new topic instead.
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 accountSign in
Already have an account? Sign in here.
Sign In Now