| Author |
Message |
mini987
Newbie
Joined: 01 Dec 2011
Location: Croatia
Online Status: Offline
Posts: 8
|
   Topic: sum the parameters for the entire year
Posted: 27 Dec 2011 at 4:02am |
|
hi everyone!!!
i am having problems with creating sum formula, the thing is that I need to put into report the total sum of the books, magazines..etc. printed till that day, separately...have any ideas?
can anyone help me?? :)
|
 IP Logged |
|
|
kostya1122
Senior Member
Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
|
Posted: 27 Dec 2011 at 10:35am |
|
something like this
magazines
if {table.type} = "magazines" and {table.date} <= date(yyyy,mm,dd) then
sum({table.field to summarize}
books
if {table.type} = "books" and {table.date} <= date(yyyy,mm,dd) then
sum({table.field to summarize}
Edited by kostya1122 - 27 Dec 2011 at 10:36am
|
|
IP Logged |
|
mini987
Newbie
Joined: 01 Dec 2011
Location: Croatia
Online Status: Offline
Posts: 8
|
Posted: 28 Dec 2011 at 3:21am |
|
not quite :( i tryed with your formula, but it doesn't work
for every job that we do we have new report, and depending of a job my class-ID changes, so report no. 3456 have class-ID 210, then next report no. 3457 have class-ID 125, and what I need is that every time on each report is the sum of quantity of earlier class-ID
for example: class-ID is 210, and the quantity is 10 000, and next time I have class-ID 210 that quantities sums
but thanks a lot for your response!!! :)
|
|
IP Logged |
|
kostya1122
Senior Member
Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
|
Posted: 28 Dec 2011 at 5:17am |
|
if {table.class-ID} = 210 and {table.date} <= date(yyyy,mm,dd) then
sum({table.quantity}
|
|
IP Logged |
|
mini987
Newbie
Joined: 01 Dec 2011
Location: Croatia
Online Status: Offline
Posts: 8
|
Posted: 28 Dec 2011 at 7:45pm |
|
i put it already yesterday like that, but it doesn't work, will try to put job-id in the range
|
|
IP Logged |
|
|
|
