SUM Aggregate Function with Band and Flags in the Syntax Sometimes Returns Null

Mike Monjian

Hi

I have the following issue with the SUM aggregate function, using the same data:

If I use SUM with the following format everything works fine:
[sum(<frQuery1."QTYSUM">)]

If I use SUM with the following format (with band & Flags), the result is sometimes NULL:
[sum(<frQuery1."QTYSUM">, MasterData1, 1)]

Has anyone come across the same issue?

FR 5.3.16

gordk

in which band is the memo containg that expression being used in? should be in footers

Mike Monjian

It is in the GroupFooter band. And as I wrote earlier, everything works fine when I use the format:

[sum(<frQuery1."QTYSUM">)]