Jump to content
Sign in to follow this  
juanito2004

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 this post


Link to post
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 this post


Link to post
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 this post


Link to post
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.

Thanks for your time.

Share this post


Link to post
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 this post


Link to post
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 this post


Link to post
Share on other sites

Hi Juanito,

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

what you had in mind.

Dan

Share this post


Link to post
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 this post


Link to post
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 this post


Link to post
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.

Dan-A, thanks for your reply, you have another PM

Share this post


Link to post
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 this post


Link to post
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 this post


Link to post
Share on other sites

Attachments were broken that day.

Share this post


Link to post
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.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.