October 1, 200817 yr Hello, I am trying to do something wich is kinda complicated to me since I am a recently FM user. What I've to is something like this: _____________________________________________ Field 0 | Field 1 | Field 2 | Field 3 | September | 20€ | description | checkbox | November | 30€ | " | checkbox | _____________________________________________| --- Total = ? How can I sum the values on Field 1 so it would give me the result on Total field. The values on field 1 are already there , they are always the same, but they only Sum when I click on the checkbox. Can anyone help me! Thanks and sorry for my bad english. [email protected]
October 2, 200817 yr create a calculated field If( not isEmpty( field 3 ) ; field 1 ; 0 ) Then the Total will be a summary field based on this field as it will only contain values of field one if the checkbox is not empty. Edited October 2, 200817 yr by Guest
October 2, 200817 yr Author create a calculated field If( not isEmpty( field 3 ) ; field 1 ; 0 ) Then the Total will be a summary field based on this field as it will only contain values of field one if the checkbox is not empty. I am still completely lost. The calculated field you said to create is a new one or it's one of the existed. And the sumary field only allows me to sum one field, and i have at least 12, since each monthly fee is an individual field. I don't know if there's an other way to do it.
October 2, 200817 yr We need a better description of what you have, and what you want to do with it. At first you said you wanted to "sum the values on Field 1", presumably meaning the sum of Field 1 values in all records of the found set. This would be accomplished by a summary field defined as total of Field 1. Now you say you need the sum of 12 fields. I believe your 12 fields should be in fact 12 records, but you could define a calculation field = Sum ( Field 1 ; Field 2 ; Field 3 ; ... Field 12 ) This would sum the 12 fields in each individual record. For the total, you would again use a summary field to total the calculation field. I have no idea what role the checkbox field plays in this.
October 2, 200817 yr Author Hi again, What i want is someway explained in the pdf file attached or here PDF Sorry for my bad english again. Any help would be great. helpme.pdf
November 7, 200817 yr Author Thanks for the help, actually it's something like that I was looking for. But isn't there a way to change the "importo rata" so it could be automatically inserted when a new record is created? Or to have for example [color:red]2 different ways of 'monthly fees' , something like [color:blue]type A it fills the months with a kind of price and [color:blue]type B other prices, that way I could choose which one satisfies me more at the time.
November 7, 200817 yr But isn't there a way to change the "importo rata" so it could be automatically inserted when a new record is created? Yes, there are many ways... But where do you wish to insert those values ? In a new table ? In a new field ? In a global repeating field ? Hard coded ?
November 7, 200817 yr Author I don't know which one would be best or easy to change later the values, any way would be great if in future I won't have to type the fee for each month over and over.
December 11, 200817 yr Author That's something like! I will try to figure it out so I can learn something from it. Thank you very much. Happy things to you.
Create an account or sign in to comment