Total Vs Move

[rbvcbr]

I put the following formula, calculation works. when highlighted this field to "Sum (total)", it show is "Move" instead "instert summary". Any tips please to "insert summary" (want to total this field). Thanks,

if {JCT_CURRENT__TRANSACTION.Accounting_Date} = maximum({JCT_CURRENT__TRANSACTION.Accounting_Date})
then
tonumber({JCT_CURRENT__TRANSACTION.Amount})

 

[lbass]

Since the formula references a summary within it, it cannot be summarized in the usual way.

Is it really your intent to return one only transactions on one day? Or are you looking for the most recent date per some group?

Anyway, you could use a variable to do this, as in:

whileprintingrecords;
numbervar sumamt := sumamt + {@yourformula};

In the report footer, you would use this formula to display the results:

whileprintingrecords;
numbervar sumamt;

If you want the sum at a group level, you would need a reset formula in the group header:

whileprintingrecords;
numbervar sumamt;
if not inrepeatedgroupheader then
sumamt := 0;

-LB