Search the Community
Showing results for tags 'total'.
Found 4 results
pomilpetan posted a topic in PrintingGood morning everyone I'm creating a database where I have to print a report. I created the whole structure but I'm at a block. The report is on several pages and I do not find the solution to be able to have at the bottom of each page the subtotal. The section is inserted, in fact at the end of the list I find the result. But if the list is longer than a page, I do not have the data of the subtotal but I find it on the second page at the end of the list. I tried to change the field settings by setting total progressive in the options and inserting it in the footer section but I always find the total integer, while if I look at the data in the table format the field has progressive values Could someone help me on this? I have been reading manuals and internet for two days but I do not find the solution (hoping there is) Thank you all
FMData12 posted a topic in Calculation Engine (Define Fields)Hi, I have a database containing all sales i make for different clients. I'd like to make a running total field for all sales in the first quarter, another for the second quarter etc. So in the end i can easily see how much i made each quarter. This field should self update upon new sales. How can i do this? Found a way around by doing a search for all 1st quarter fields and copying total invoice value to a container field. Very unhandy and i have to fire a script each time a update... Any help is appreciated very much!
Hi, I wonder if there is an easy way to repeat the calculated totals of sub-summary lines, say, at the end of the report. I have an invoice like this: A-Items Item A.123 $1 item A.124 $2 Item A.125 $1 Total Items A $4 B-Items Item B.012 $2 Total Items B $2 C-Items Item C.111 $5 Item C.112 $5 Total Items C $10 Grand Total $16 But, before the grand total, I would like to include a couple of extra lines. I would like to repeat all the sub-summary lines of the report once more, like this Total Items A $4 Total Items B $2 Total Items C $10 Grand Total $16 Is this possible without reinventing the wheel? Thanks a lot for any help! Gary
MariaAux posted a topic in Calculation Engine (Define Fields)Hi There, I have a database with 1000's of children's games. I have teachers in other parts of the world classifying the games into categories. When they log in, a find is performed to bring up a specific 100 games for that teacher to categorise based on topic. The teacher categorising the Games to teach the animals (100 games) has a readout telling the teacher that s/he is on E.g. Game 4 out of 100 which is a calcualtion I made. Once they are done they check the 'Done' box in the Games::Done field. The teachers have requested that there is a readout telling them how many games they have completed and I am struggling to create a formula to acheive this. I imagine I need the count function to find not only the Games::Done that have been checked 'Done' but only those within the Games::Topic = Animals. I have to admit, I am bit amiss as to how to create such a formula. Would it be a summary field or a count function? Thanks so much for all your advice, Maria