Help!

[deaconpt]

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]

[Ocean West]

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, 2008 by Guest

[deaconpt]

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.

[comment]

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.

[deaconpt]

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

[deaconpt]

Hi again,

any ideaS?

[comment]

I still don't understand what I am looking at.

[deaconpt]

Anyone can help me?

[Ocean West]

Can you post a sample of your file?

[deaconpt]

Here it is, I hope you can understand.

payment.zip

[Raybaudi]

Hi

this is an idea from Italy :

Pagamenti.zip

[deaconpt]

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.

[Raybaudi]

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 ?

[deaconpt]

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.

[deaconpt]

Anyone can help here?

[Raybaudi]

Hi

this is a way...

Let me know if there are more problems.

Pagamenti1.zip

[deaconpt]

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.