Can you describe what you have and what you want in more detail? What exactly makes the entry "Distinct"?
Are you using FileMaker 12?
by distinct I mean a single return value
and not one value in the row on a portla in several fields,just first..the next value would be the next total from other realtion conected to this field
I am using file maker 11
I still don't know what you want. A single value from what set of data? All the line item records for the invoice? A selected subset that have a specific value in common?
Do you have this typical set of relationships for your invoice?
(LineItems are called "InvoiceData" in the FileMaker 12 Invoices Starter Solution.)
yes there is a relationship like te one you discribed above
what I want is a total of my products leaving the warehouse, I get them substracting them from line items in warehouse...if there are 4 products then I get total in several times like this
items in items out total
100 4 20
200 6 20
300 10 20
what I want is this date field
100 4 23/11/2012 20
so next calculation
would be date field
100 10 23 /11/2012 20
200 10 24/11/2012 30
is that posibble
Specific to one invoice?
Your total does not appear to be "distiinct" which makes me think that I am missing something. the total of 20 appears to be a total of all items out and does not appear to have anything to do with items in.
I'm thinking you need a summary report layout based on your line items table but am still unclear as to what makes one row of data different from another in your example.
not missing something, I am missing a point, and yes you re right they dont have anything to do with litems in , just items left in the stock .the rows of data would be linked to date when that action is happening or happened , but i dont know how to link the two
if such and such date is set show result of a total of all items leaving the warehouse
if new date then total 2 etc..
thats where I blank ...I donnt know how to set values and variables for the fields, link betwweeen dates and totals.
Ok, let's see if this is what you have in mind.
You want a total of all items shipped for each date that the item was ordered? or Shipped? (Could be the same, but not in all such businesses).
And you want these totals for a single date? a Range of dates?
This type of report is possible:
Such a report can, if desired be further broken down by product ID if such is desirable to give you totals for each item shipped by date.
You can create a layout based on your line items table. Replace the body layout part with a sub summary layout part "when sorted by Date".
Define a summary field to compute the total of your Quantity field.
Place the date and this summary field inside the sub summary layout part.
Find the records you want for your report, sort them by date and you'll get the result shown in this post.
can you open my file, can you show me I am really strugling to show it on original report, i can show a sumarry like thea on new layout ,but not on the one I need
You may not be able to do what I described on your existing report.
I'd have to see your report layout.
You can upload your file to a file sharing site such as Drop Box and then post the download link to it here. (Or Private Message it to me if you don't wish to make the link public.)
Here is the file called storage in the Micael folder
the user name is Admin
the password is 123
+whooduld you be so kind to tell me your email , if this hotlink doesnt work