?
Solved

Sum of (vertical) fields in Reslts Page

Posted on 2003-02-19
2
Medium Priority
?
318 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

770 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