hi everyone,

i have problems with writing formula,

i need data from the same field for different dates, for example

{InvReceiptTran.Qty-on-Hand-Purchase} on the 1/1/2011 then
{InvReceiptTran.Qty-on-Hand-Purchase} on the 31/2/2011 and so on...

could anyone help please?!

field is the income of merchandise that was on that day on warehouse
it is something like this:

on 1/1/2011 was:

books - 1250
magazines - 1000
and so on....

i already put the parameter for time, so i can select date range, from 1/1/2011 to 31/12/2011, but on the 1/1/2011 we already had some books on warehouse, and i need to sum them with the rest of the books that came and went out from the store, and because of that i need the formula that will give me exact number on specified date :)

you could try something like
first create a formula
books
if table.date = date(2011,1,1) and
table.data_type = "books" then table.item_qty

next create a formula for sum
books_sum
sum(@books)