Posted 8 September 2017, 2:54 pm ESTHow 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.
Sum formula for CURRENCY cell type
Posted by: santoshi-fp on 8 September 2017, 2:54 pm EST
Replied 8 September 2017, 2:54 pm EST
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.
Hope it will help you. Please let me know if you have any queries further.
Replied 8 September 2017, 2:54 pm ESTThanks Manpreet. Its working now.