Search the Community
Showing results for tags 'total'.
Found 3 results
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