Jump to content
Salesforce and other SMB Solutions are coming soon. ×

probably simple - stuck with getsummary?


axemanchris
 Share

Recommended Posts

Hi all;

 

I've been searching the net and this forum for two days now, and can't believe I haven't found the answer to something so apparently elementary. I'm using fmp5.5 and am setting up a database to keep track of merchandise sales for my band.

 

I have an inventory of shirts. I have three fields, each with a value list assigned.

Size - S, M, L, XL, XXL

Colour - Black, Red

Style - Regular T, Ladies T

 

I have input numbers for each, (a fourth field called 'quantity') so a record might look like this...

 

Size = L

Colour = Red

Style = Regular T

Quantity = 4

 

I have a record for small black regular, medium black regular, small black ladies T, etc., along with a corresponding quantity for my inventory.

 

Now let's say I want to make a summary in chart form that would look like this...

 

Black Red Ladies Black

Small 2 1 3

Med 5 2 4

Large 4 2 3

 

etc. **not actual numbers**

 

Each number would require a summary based on three things - size, colour, and style.

 

I want to look up the number of small black regular shirts, find a value of 2, and place it in the field on the chart. ... And continue for each cell on the chart.

 

I've mucked about with a summary field and can get it to display on every record that I have a total of 26 shirts, but can't get FM to count only specific shirts that meed specific criteria.

 

I've used a getsummary function to tell me on each record that I have black shirts or not using an if... count function. But not an If (colour="black", sum="quantity", 0) kind of thing.

 

How can I do this?

 

Thanks;

Chris

Link to comment
Share on other sites

Black Red Ladies Black

Small...........2.............1......................3

Med............5..............2.....................4

Large..........4..............2.....................3

 

Sorry - hopefully the dots will help to format this so it makes a little more sense.

 

CT

Link to comment
Share on other sites

.............. Black........ Red .............Ladies Black

Small...........2.............1................... ...3

Med............5..............2................... ..4

Large..........4..............2................... ..3

 

Or maybe that one....

 

CT

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use