Bempster

This is cool. I am creating an Ink Inventory system for our ink kitchen. We mix our own flex inks for PMS and special match colors. My question is for Robert Schaub. How can I incorporate your list into my database? I have a growing list of PMS inks that we have in stock and would like to show a color swatch of the PMS color beside the name. Thanks in advance! Bempster

I have a layout that is designed to print on a catalog envelope. Problem is that the envelope works better if it is fed from the bottom. Is there a way to script in a page rotation before printing. It does not appear as an option in the print dialog.

Yeah!!! I figured it out and got what I needed. Ended up using a bar chart because it showed the occurrences more clearly. thanks again.

Thanks for the help Members. You definitely have me on the right track. Only thing now is my sPercentage is coming up 0. Could it be due to my Value field (Plate Cylinder) being a calculation? (DieInventory::Size Around + DieInventory::Space Around) * Plate #Around * 8, Result Number

Maybe I'm shooting for the wrong thing. The second scenario looks more like what I need. I would also like to show the number of times each is used. Based on your example it would be 20: 3 - 50% 30: 2 - 33.3333% 40: 1 - 16.6667% Any idea on how I would go about making a record that would get me there?

Hi, I'm pretty new to FileMaker and am trying to create a report and chart that shows the occurrences of a various cylinder sizes that we use in our facility. I have a list of items each of which has a cylinder size assigned. What I am ultimately looking for is a report and pie chart with the slices showing the percentage of use forr each size. I have tried the example from the Filemaker Support page "Counting the Number of Unique Values in a Field" and cant quite figure out what the calculation entries in field "B" should be (I bolded the entries that I don't understand). Below is the description of the four fields that are required. I have replaced my entries where applicable A) The first field is a summary field called "Cylinder Count": Cylinder Count (Summary) = Count of Plate Cylinder This will count the records. B)The second field is a calculation which produces the number of records within a group: Break (Calculation, Number result) = Summary (Region Count, Region) C) The third field is a calculation that returns a numerical weight of a record in the group when compared to the total records for the group. For example, for a set of ten records, this calculation returns the fraction, 0.1 (i.e., 1/10). This is the formula: Occurrence (Calculation, Number result) = 1 / Break D) The fourth field is another summary field that totals the fractions generated by the third field above, giving you the total of unique values in the field: NmbrOfRegions (Summary) = Total of Occurrence My result comes up as a decimal instead of a count. I think if I can place the correct calculation in the Break field it will work. Thanks in advance for any help that someone can offer.