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 |
|
|