# Calculation of calculation. Help please

## Recommended Posts

An example would be the best way to describe what I am trying to do.

Let's say I have a database with 100 records. each record has a classification field. the first ten have A in that field. The next ten B. The next ten C and so on...

All the records also have a calculated field.

I would like to know if in another layout I can have a field that would give me the sum of the calculated field for each of the classifications (A,B,C etc...) so the sum of all the A records, the sum of all the B records ...... so I can sort them by amount. I have managed to create the sum but for each individual group. I need to have them all in one screen.

Any help is much appreciated

##### Share on other sites

When you say you've created the sum, you probably mean with a summary field. You can also summarize information from sets of records using relationships and the Sum() function. If you create a relationship which isolates the records with Classification = "A", you can create a calculated field:

Total (calculation, number) = Summary(Relationship::Amount)

If your (self) relationship matches Classification <--> Classification, the field Total can be placed in a subsummary part by Classification. When you sort by Total(first) then Classification(second), you will get the result you desire (in preview mode).

-bd

##### Share on other sites

yes, it was a summary field, but I had to do a find for each set (A,B,C...)

I thank you for your answer but I am extremely new to this software and although I tried to understand what you said I just couldn't. Would it be possible to have a step by step guide of what I have to do to get the result I am looking for please?

##### Share on other sites

I have been trying to work out the problem logically using your instructions but my knowledge of filemaker isn't extensive enough! for an expert your explanation is simple but for a total beginner is just too complicated. Without detail, step by step instructions this does not help me.

##### Share on other sites

I think what liveoak is saying is to build a relationship with your database...

Create a field (ClassificationToMatch) that would relate to your classification field.

When the fields have a matching value ONLY those matching records will be

visible in the portal that you would have on a layout.

You can then use a summary field to add or to count the qty of "a" in the portal.

Then when you change the match to "b" you will see the summary for

all of "b" in the portal. etc.

Hope this helps.

Dan

##### Share on other sites

Thanks for the try Dan-A

Maybe if we try part by part.

LiveOak wrote:

"If you create a relationship which isolates the records with Classification = "A", "

How do I create that relationship?

then he wrote,

"you can create a calculated field:

Total (calculation, number) = Summary(Relationship::Amount)"

what does each part of this calculation refer to?

and finally:

"If your (self) relationship matches Classification <--> Classification, the field Total can be placed in a subsummary part by Classification."

The second part of that is greek to me.

I think this is too advanced for me right now, I should give up.

##### Share on other sites

Hi Juanito,

Look at this attachement in FM7, let me know if this is

Dan

##### Share on other sites

Hi Again Juanito,

Sorry for being a dope....

I just saw that you are using FM 5...

Here is a new attachement in FM5 format

HTH

Dan

##### Share on other sites

Make another file, called Classification, with the first record being A, the second B, etc.; connect the Classification field in this file to the Classification field in the other file. Then in the first table make a summary field for the calculated field. Finally, put that field on the Classification layout. You will then have the totals of each classification displayed.

##### Share on other sites

thanks transpower. I think I understand what you just wrote. I'll give it a try and let you know if I managed it.

##### Share on other sites

Hey Juanito,

I just tried the attachement & i got a message "page not found"

maybe there is a problem with the upload I did!!

Dan

##### Share on other sites

Can you try to upload the file again please Dan-A? It is strange that we both get "page not found" when it says that there are over 20 downloads of the attachment (or maybe that just a click count)

##### Share on other sites

Attachments were broken that day.

##### Share on other sites

Hi All,

This is it ...take 3 on the upload

Dan

ClassificationExample.zip

##### Share on other sites

Got ii this time. Going to have a look at it right now. Thanks Dan-A, will let you know if that is what I was looking for.

## Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×

• ### Who Viewed the Topic

1 member has viewed this topic:
SRBENET
×
×
• Create New...