Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sum of (vertical) fields in Reslts Page

Posted on 2003-02-19
2
Medium Priority
?
321 Views
Last Modified: 2010-04-27
Hello People!
With great hope that someone has an advice/solution I present my problem. I am new to FileMaker (FMPro6) so I would apprechiate all of the help.
Here is the DB structure (the actual field names differ but for the ease of understanding...):
=====Reports.fm6================================
-Location (text)
-ItemPrice(number)
-Quantity(number)
-TotalSaleForThisItem (calcualtion=ItemPrice x Qunatity)
-Date(date-autoenter)
--TotalDailySaleBasedOnDateRangeSelected(??????)
===================================================
the scenario is:
user goes to search page (CMDL custom web-pub) that does sorting just fine.So if user selects

Location:Los Angeles
Date:(Range)1/1/2002...1/7/2002

I would like to get the results:
Location   |    Item Price  |Quantity  |TotalSale  |date
======================================================
1.Los Angeles|    50         |  2       |100       |1/1/2002
2.Los Angeles|    20         |  7       |140       |1/2/2002
3...                                               4...                                               5...                                               6.                                                
7.                                                
======================================================
for the selected time frame (one week worth of time)
1/1/2002-->1/7/2002
WEEKLY_TOTALQuantity=xxxx WEEKLY_TOTALSale=$xxxx                      

SO in other words a weekly report where the week starts based on my date selection and Verital Summ of resulting fields per page?
IS this possible?My background is in VBscript and ASP not FM scripting sooo....
I am at the point where I would really apprechiate your help...and IF this is NOT possible...CHANGE OUR WHOLE DB to Access...maybe?! :( help help help
Thank you guys......
0
Comment
Question by:lebisol
2 Comments
 
LVL 1

Accepted Solution

by:
vux984 earned 540 total points
ID: 8002265
Quite frankly, I have little experience with CDML myself. However, this may get you where you want to go...

define two summary fields (totaldollars, and totalqty), and set them to "Total of dollars", and total of quantity respectively.

Summary fields simply perform the selected operation (total of, average of, standard deviation of...) on the records in the current "found set". Since the CDML "find query" will generate the correct found set you should be able to simply pull these field values to the web in the appropriate place via the appropriate cdml tag.

(Note that the summary fields will be identical for every record in the found set so it doesn't matter which record you get it from.)
 
-d
0
 

Author Comment

by:lebisol
ID: 8009727
Thank you very much!
One thing that confused me is that I did had those totoal defined but when viewed in FileMaker they "add the current record's totals"...while as you said they "add found totals" when CDML used...strange...(my background is in ASP).So as long as those fields stayed out of "repeated region" they add just great!
In any way this worked just fine!
Thank you....
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses
Course of the Month13 days, 16 hours left to enroll

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question