I have created a simple report using FML. If I use "ACROSS YEAR", then rows in the final report that have no data do not sum correctly. If I change it to "BY YEAR" - the data sums correctly.

TABLE FILE CHRIS_GP_CHART_IBI
SUM 
     ACTUAL/D12.2CB
     BUDGET
BY ACCOUNT_CODE_FIRST_SEGMENT
ACROSS YEAR
FOR
     CHILD
'xxxxxx' ADD ALL AS 'R1' LABEL R1 OVER 
'xxxxxx' AS 'R2' LABEL R2 OVER 
RECAP R3/D12.2=R1-R2;
 AS 'R1-R2' OVER 
" " LABEL R4 OVER 
'xxxxxxx' ADD ALL AS 'R5' LABEL R5 OVER 
'xxxxxx' ADD ALL AS 'R6' LABEL R6 OVER 
'xxxxxx' ADD ALL AS 'R7' LABEL R7 OVER 
'xxxxxxx' ADD ALL AS 'R8' LABEL R8 OVER 
'xxxxxxxxx' ADD ALL AS 'R9' LABEL R9 OVER 
'xxxxxxxx' ADD ALL AS 'R10' LABEL R10 OVER 
" " LABEL R11 OVER 
" " LABEL R12 OVER 
BAR AS '-' OVER 
RECAP R14/D12.2=R5+R6+R7+R8+R9+R10;
 AS 'R5+R6+R7+R8+R9+R10' OVER 
" " LABEL R15 OVER 
BAR AS '-' OVER 
BAR AS '-' OVER 
'5110' ADD ALL AS 'R18' LABEL R18 OVER 
BAR AS '-' OVER 
RECAP R20/D12.2=R3-(R14+R18);
 AS 'R3-(R14+R18)' OVER 
" " LABEL R21 OVER 
" " LABEL R22 OVER 
" " LABEL R23
HEADING
""
FOOTING
""
WHERE ( YEAR GE 2005 ) AND ( ACCOUNT_CODE_FIRST_SEGMENT EQ 101 );
ON TABLE SET PAGE-NUM OFF 
ON TABLE SET FORMULTIPLE ON 
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET BLANKINDENT ON
ON TABLE SET HTMLCSS ON  

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

Hi Chris,

I passed this one to internals and here is the suggestion: we cannot recreate the problem here, so please contact Information Builders' Customer Support Services and open a case for assistance. We may need also need additional info, such as masters and data if possible.

To open a case, please either call at 1-800-736-6130, or access online InfoResponse.

Hope this helps.

Cheers,

Kerry