Sum formula for CURRENCY cell type

Posted by: santoshi-fp on 8 September 2017, 2:54 pm EST

  • Posted 8 September 2017, 2:54 pm EST

    How can I write a formula for Currency cell type to calculate the sum of an entire column. I have tried "Sum(AV1:AV3)". Its not working at all. I am trying to add the sum formula in the column footer. Any help is much appreciated.
  • Replied 8 September 2017, 2:54 pm EST

    Hello,

    You would need to use the SetAggregationType method of the ColumnFooter class to add a formula in the column footer, that displays the sum of the entire column in the column footer. Please have a look at the following link which describes how you could add a formula to the ColumnFooter.

     http://www.clubfarpoint.com/FarPointSupportSite/Modules/Docs/SpreadWin5Help/FarPOint.Win.Spread~FarPoint.Win.Spread.ColumnFooter~SetAggregationType.html

    Hope it will help you. Please let me know if you have any queries further.

    Thanks,

    Manpreet Kaur

  • Replied 8 September 2017, 2:54 pm EST

    Thanks Manpreet. Its working now.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels