5 Replies Latest reply: Sep 9, 2013 4:58 PM by Anosh Nathaniel

# How to Use a Column in SUM Expression

HI, I am trying to use one column as an filter condition for my sum Expression, like this: =SUM({} EngedMem_Rnk) Where Date is a column in my data set, but it’s not working. If I remove Date condition from my expression, its working fine. =SUM({} EngedMem_Rnk) Any idea, what I am missing I need to Include Date Column in my sum Expression. Thanks Sandeep

• ###### Re: How to Use a Column in SUM Expression

Hi,

Use like this for max date filter using set analysis:

=Sum({<DateField={"\$=(max(DateField))"}>}EngedMem_Rnk)

Regards,

• ###### Re: How to Use a Column in SUM Expression

It's not working, I have a question, why I should use Max, as I said Date is a column, value of date column for each row should get considered while calculation.

• ###### Re: How to Use a Column in SUM Expression

Hi Sandeep,

What date condition you are writing? Please elaborate your problem or provide qvw.

Regards,

Anosh

• ###### Re: How to Use a Column in SUM Expression

Hey Anosh, I am trying to calculate my SUM on the basic of three conditions, like bellow =SUM({} EngedMem_Rnk) Where in first condition DateType = {3}, 3 is an value I am putting. first condition ENG_DATE = {Date}, Date is a Column in my Data Set, from which I need to calculate.

• ###### Re: How to Use a Column in SUM Expression

Hi Sandeep,

Set analysis doesn't calculate RHS clause row by row. for eg if expression is: sum({<Year={abc}>} amount) where abc is caculated only once and used in all records, thats why it should be Max,Min or something else to return only one value. If you want to use Date in your calcuation then put Date colume in dimension and the expression will automatically start taking it into consideration.

Hope this help,

Anosh