Sorry to not be clear. that is one option but you canm avoid it with the second option.
Create 6 different formulas, one per month and do an if then datediff function in each to get the total value for the month (often will be zero), something like this for the 6 month ago formula
if month(table.startdate)>month(currentdate)-6 then 0 else
datediff("n",
if then here to get month startvalue,
if then get month endvalue
)
YOu can then sum each of the formula fields seperately to get the sums for the last 6 months and they can be graphed.
Edited by DBlank - 03 Sep 2009 at 6:57am
IP Logged
