# SUM of column
**URL:** https://www.dynamicsuser.net/t/sum-of-column/54998
**Category:** Developer Forum
**Created:** [September 21, 2014, 4:17pm UTC](https://www.dynamicsuser.net/t/sum-of-column/54998 "2014-09-21T16:17:10Z")
**Posts on this page:** 9
**Page:** 1
### Author:  [@lalit.jivnani](https://www.dynamicsuser.net/u/lalit.jivnani)
#### Post date: [September 21, 2014, 4:17pm UTC](https://www.dynamicsuser.net/t/sum-of-column/54998/1 "2014-09-21T16:17:10Z")
Hello All,
I have a calculative field in my **SSRS** report body and for which i want to sum all the values for that column.
As we cannot use **SUM** function in report body, i tried using custom code but i think AX does not support it.
So how can i sum up all the values ?
---
### Author:  [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)
#### Post date: [September 21, 2014, 11:00pm UTC](https://www.dynamicsuser.net/t/sum-of-column/54998/2 "2014-09-21T23:00:09Z")
Why can’t you use an expression with SUM function? That’s how it’s normally done.
---
### Author:  [@lalit.jivnani](https://www.dynamicsuser.net/u/lalit.jivnani)
#### Post date: [September 22, 2014, 11:12am UTC](https://www.dynamicsuser.net/t/sum-of-column/54998/3 "2014-09-22T11:12:04Z")
I have used the SUM function in expression only but while deploying it gives error as We cannot use the SUM function against the Report items and it is must for me to use the Report items as it is a calculative one.
I do not have dataset fields to use in SUM function.
So is there any way Martin ?
---
### Author:  [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)
#### Post date: [September 22, 2014, 1:02pm UTC](https://www.dynamicsuser.net/t/sum-of-column/54998/4 "2014-09-22T13:02:07Z")
Could you explain to me what do you mean by “calculative field” if it’s not a dataset field? Is it a data method? How is the value calculated?
---
### Author:  [@lalit.jivnani](https://www.dynamicsuser.net/u/lalit.jivnani)
#### Post date: [September 22, 2014, 1:43pm UTC](https://www.dynamicsuser.net/t/sum-of-column/54998/5 "2014-09-22T13:43:31Z")
Actually the value to that column is calculated by several dataset fields value and using some of the functions.
So for that particular all column values,i want to SUM up all those.
---
### Author:  [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)
#### Post date: [September 22, 2014, 1:55pm UTC](https://www.dynamicsuser.net/t/sum-of-column/54998/6 "2014-09-22T13:55:24Z")
Just use a similar calculation in your total summary (or maybe even the same calculation with a different [scope](http://technet.microsoft.com/en-us/library/ms159673%28v=sql.100%29.aspx)). I can’t be more specific since I don’t know your code.
---
### Author:  [@lalit.jivnani](https://www.dynamicsuser.net/u/lalit.jivnani)
#### Post date: [September 22, 2014, 2:36pm UTC](https://www.dynamicsuser.net/t/sum-of-column/54998/7 "2014-09-22T14:36:23Z")
Ok Let me share you the code.
### =abs(DateDiff(“d”,DateSerial(Year(Fields!AccountingDate.Value), Month(fields!AccountingDate.Value), “1”).AddMonths(1).AddDays(-1),
Fields!AccountingDate.Value))
The whole above expression is written in text box.
### So basically the column calculates the total number of days left in the month based on the Accounting date for each record appearing in the table.
So now as we got the remaining days for each records, i want to sum up those remaining days value .
Hope if now you can get my point by the code or else i need to think some other way round.
###
---
### Author:  [@MartinDrab](https://www.dynamicsuser.net/u/MartinDrab)
#### Post date: [September 22, 2014, 6:01pm UTC](https://www.dynamicsuser.net/t/sum-of-column/54998/8 "2014-09-22T18:01:52Z")
Actually, it’s easier than I thought.
I simplified your expression a little bit to make it more compact:
```auto
=-DateDiff(
"d",
DateSerial(Year(Fields!AccountingDate.Value), Month(Fields!AccountingDate.Value) + 1, 0),
Fields!AccountingDate.Value)
```
Then I added a row to the tablix _(Outside Group - Below)_. There I simply summed up the expression:
```auto
=SUM(-DateDiff(
"d",
DateSerial(Year(Fields!AccountingDate.Value), Month(Fields!AccountingDate.Value) + 1, 0),
Fields!AccountingDate.Value))
```
It works very well.
---
### Author:  [@lalit.jivnani](https://www.dynamicsuser.net/u/lalit.jivnani)
#### Post date: [September 24, 2014, 2:02pm UTC](https://www.dynamicsuser.net/t/sum-of-column/54998/9 "2014-09-24T14:02:34Z")
Hello Martin,
Thanks for the way you suggested. It did not actually resolved my issue but i have implemented another way of achieving the values.
Hope this solution may work for several other users.
🙂