How to use formula for SUM

[former_member1229785]

Dear All

       Here i have facing problem with sum of formula, i have one data field name AMOUNT i need formula for total amount which added in amount field , in that AMOUNT field data type is string

how to do it...

[abhilash_kumar · Accepted solution]

Hi Prasanna,

1) First convert the Amount field to number using this formula:

If isNumeric({Amount}) then

     ToNumber({Amount})

2) Go to Insert > Summary > Choose this formula field as the Field To Summary > Choose Sum as the summary operation > Place the summary on a section

-Abhilash

[former_member1229785]

Thanks Abhilash it working fine...