Why won't my new column show the sigma>

Epicor ERP 10
1

I have added a new column to the Purchase History grid on the purchase advisor screen that computes the number of days between the receipt date and the order date. This works well, the only “issue” that I see is that when I right click on the grid and show summaries, my new field doesn’t show the sigma to summarize it even though the value is numeric. Any ideas. Here is the code snippet of the calculation and how I set the value of the new column.

DateTime receiptDate = Convert.ToDateTime(row.Cells[“ReceiptDate”].Value.ToString());
DateTime orderDate = Convert.ToDateTime(row.Cells[“OrderDate”].Value.ToString());
row.Cells[“DaysLead”].Value = ((TimeSpan)(receiptDate - orderDate)).Days;

2

Try using the decimal type, see if that works. Also how are you adding the column?

3

This is how I add the column:

grid.DisplayLayout.Bands[0].Columns.Add(“DaysLead”);
grid.DisplayLayout.Bands[0].Columns[“DaysLead”].DataType = typeof(int);

4

I am not great with infragistics, but this could be something to look into:

5

I have a similar customization on a deferent screen where the sigma does show up on the custom column. The only difference is that in the other screen I am doing math with numbers and in this screen, I am doing math with dates. Not sure if this has anything to do with it or not.