Line Chart Question 1

[dscoiho]

I am using CR10 with ODBC connection on DB2. I have a line chart that shows cumulative total for each month but limited to previous month (currently April) seperated by current and previous year. The data is based off a running total of this formula

if {TRANSACTION_HISTORY.TRADE_YEAR}=2006 and
{TRANSACTION_HISTORY.TRADE_MONTH}< Month(CurrentDate) and
{FUNDS.FUND_GROUP}in ["AA","EQ","FI","TE","MA"]and
{TRANSACTION_HISTORY.TRADE_CLASS}in ['S', 'Z']then {TRANSACTION_HISTORY.GROSS_AMOUNT}

(I do have 2nd running total for previous year off a formula similiar to the above formula)

What I am trying to do is have the lines on the chart to either drop to zero or stop at the previous month. Currently it runs straight across to December with current amount represented.

Any idea would be appreciated.

 

[lbass]

You could try the following:

Create a formula {@null} by opening a new formula and saving the empty formula. Then try creating a formula like this:

if {TRANSACTION_HISTORY.TRADE_MONTH} < Month(CurrentDate) then
{#yourrunningtotal} else
tonumber({@null})

If your running total is a currency, remove tonumber() and place a $ in front of {@null}. Then use this new formula instead of your running total in the chart. Repeat for the other running total.

-LB