TABLE FILE BALDATA
SUM 
BALANCE AS ''
BY BRANCH

WHERE BRANCH EQ '0002'
WHERE DATE1 EQ '201102'

FOR DATAROW

TYPEA LABEL TYPEA OVER
TYPEB LABEL TYPEB OVER

RECAP TYPEHIGH = TYPEA + TYPEB;
END

I get zero for TYPEHIGH when I am expecting the sum of the two rows. What's wrong here?

Thanks,

This message has been edited. Last edited by: Francis Mariani,

A basic report with the CAR file works:

TABLE FILE CAR
SUM 
SALES AS ''

FOR SEATS

2 LABEL TYPEA OVER
4 LABEL TYPEB OVER

RECAP TYPEHIGH = TYPEA + TYPEB;
END

Solved!

For some reason, in the non-CAR report, the RECAP requires a numeric format.

(I would have deleted this whole thread, but the "Delete" option is not available in the first post.

Well, someone else may have the same issue, so its good to have available.

Besides, FML/FRL/FMR/SML/EMR or what ever its called now, can be a bit confusing.