Sum of the field of formula column

[Former Member]

Hi,

I have created formula filed "Amount" as follows:

amount : amt1+amt2+amt3;

Now I want to sum up the formua filed "Amount" to show it on report.

I have tried creating another formula filed "Totals"

totals := Sum({Amount});

Here i am getting an error like filed cannot be summed.

what is wrong in it? How can I summarize my formula field.

[abhilash_kumar]

Hi Aravind,

If amt1, amt2 and amt3 are formula fields that use print time functions or summary functions, you won't be able to use the Sum function on top of them (or use the UI to sum them up).

You would need to create another variable as Shahnawaz suggests. The only change I would make to his code on the Details section is:

WhilePrintingRecords;

numbervar Summary := Summary + amt1 + amt2 + amt3;

-Abhilash

[Former Member]

One way would be to create Summary using UI.

Second if you are adding multiple fields as amt1+amt2+amt3 then

you may place this formula in details section and re declare the variable in report footer

example

// in details section

WhilePrintingRecords;

numbervar Summary:=amt1+amt2+amt3;

// report footer

WhilePrintingRecords;

numbervar Summary;

- Shahnawaz