I am having a hard time trying to figure out how to do a bar graph comparing some accounting figures - budget and actuals. One of the amounts is in a table by accounting period while the other has a transaction date. Is this possible? I would like to put the accounting period on the x-axis. Right now I am just getting the total sum of the actuals because they are using transaction date.

DB Table #1:
Acct_period
Budget

DB Table #2
TransDate
Actuals

Here is my current code:
J1.GL20000.DEBITAMT
JOIN
GL00201.GL00201.ACTINDX IN GL00201 TO MULTIPLE GL20000.GL20000.ACTINDX
IN GL20000 TAG J0 AS J0
END
DEFINE FILE GL00201
CURR_DATE/DATE=&YYMD;
BEG_MTH/DATE=DATEMOV(CURR_DATE , 'BOM');
ACCT_PER/MDYY=HDATE(GL00201.GL00201.PERIODDT, 'MDYY');
MONTH/YYMD=BEG_MTH;
TRANS_DATE/YYMD=HDATE(J0.GL20000.TRXDATE , 'YYMD');
ACTUAL/P21.5=J0.GL20000.CRDTAMNT - J0.GL20000.DEBITAMT;
END
GRAPH FILE GL00201
-* Created by Advanced Graph Assistant
SUM J0.GL20000.ACTUAL
COMPUTE BUDGET/P21.5=ABS ( SUM.GL00201.GL00201.BUDGETAMT ) ;
BY GL00201.GL00201.ACCT_PER
WHERE GL00201.GL00201.BUDGETID EQ '2012BUDGET' AND GL00201.GL00201.ACTINDX EQ 52;
ON GRAPH PCHOLD FORMAT PDF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 8
ON GRAPH SET VAXIS 4
ON GRAPH SET UNITS INCHES
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setPlace(true);
setTextString(getSubtitle(),"2012");
setDisplay(getSubtitle(),true);
setTextString(getO1Title(),"Accounting Period");
setDisplay(getO1Title(),true);
setDisplay(getO1AltFmtFrame(),true);
setTextString(getY1Title(),"Amount");
setDisplay(getY1Title(),true);
setReverseSeries(false);
setReverseGroups(false);
setAxisSide(getO1Axis(),0);
setGridStep(getY1MajorGrid(),50000.0);
setAxisDescending(getY1Axis(),false);
setTextString(getTitle(),"Monthly Budget vs. Actual Revenue");
setDisplay(getTitle(),true);
setFontStyle(getFootnote(),1);
setTextString(getFootnote(),"*Actual values are displayed before month end close");
setDisplay(getFootnote(),true);
ENDSTYLE
END

This message has been edited. Last edited by: Kerry,

I'd like to resolve this... So, can / Would you supply some sample data or, better yet, show this dilemma using a sample IB file?

After thinking about this: You really can't mix periods and dates unless there's something common. So, consider converting your "transaction date" to an "accounting period" and GRAPH THAT.

Thanks Doug for the input.

Nyssa, I checked with our graph folks and were suggested that, it is hard to tell exactly what you are trying to do, and with the Joins and Computes, it seems to be more confusing. It is suggested that you make sure the data comes out right in a Table first. The BY field will be the X axis.

Cheers,

Kerry