Calculate sum in global field

[Antonasg]

Hi There!

i've just started with FM and im working on a stamp database atm.

i've got 3 fields, with 3 different prices on one stamp, then i have a field that uses the average calculation so i have an average.

what i want now, is a field that calculates the sum of all averages in all records, so there is a globalfield that is allways updates with that value.

Im kinda new, so i hope im makeing some sence :

Thanks i advance!!

Edited June 6, 2008 by Guest

[Fitch]

What you want is called a Summary field.

[mr_vodka]

You dont need a global field for this. You can just create a summary field that averges your cAverage calcuation field.

The summary field will be specific to your found set of records, so if you perform finds, then you should use a show all to display it for all records.

However, if you want this number to always be for all the records instead of just the found set, create a "self join" relationship and then put the summary field from your self join child table occurence on the layout.

[Antonasg]

Thank you very much, that helped!

How ever i now have antoher problem.

The calculation of average, makes alot of decimals

450,3333333333 etc etc...

Is there a way to only show the first digit?

Thanks

[mr_vodka]

Right click on the field and format the number.

[Antonasg]

Ha yeah, my bad didn't look good enough..

Thanks :

I seem to run into another problem.

I want to make a some kind of status screen,

and among other things i would like it to say how

many records that is missing a picture.

I've made this calculation:

Count ( Document ID ) - Count ( File )

But as you can see, it counts all of the container fields (File)

Is there a way so it only will count (File) that is empty?

i've been trying with some IsEmpty and if, but can't get it to work :

Thanks

[mr_vodka]

You can have a calc with IsEmpty ( File ) and then use a count on that field if its from a related TO. A count from the same table only counts the field itself... A count on a related set of records will count all the related ones. Check the help file on count.