Set Analysis Where Date Is Greater Than

[Anonymous]

Trying to only calculate spend where a certain date field is greater than 12/01/2014. Current syntax I have is below but it is not working:

sum({<

Date = Date > {'12/01/2014'} }>}

Spend)

Any help is appreciated.

Thank you,

- dave

[swuehl]

Try

sum(

{<Date = {">'12/01/2014'"} >}

Spend)

[b_garside · Accepted solution]

This will work. However you may not want a static/hard coded date search parameter.

Sum({$< [Data Type]={'A'} , Date={"> 12/01/2014"}>} Spend)

[Anonymous]

That did not seem to work. I have an additional statement in the set analysis ... Maybe this is why it does not work ...

sum({<

[Data Type]={'A'},

Date = {">'12/01/2014'"}>}

[Spend])

[Anonymous]

Brian - Copied and pasted your solution verbatim but its not working for me. Perhaps I am doing something wrong ...

EDIT: I had an extra space between > and the date ... This now works. Thank you .

[b_garside]

Your welcome, Glad it worked.

Yeah Set Analysis is not to forgiving on syntax issues.

[vanand3535]

try this:-

Sum({$< [Data Type]={'A'} , Date={"> 12/01/2014"}>} Spend)

[b_garside]

Yeah the extra space was my bad. Glad you got it to work

[publication1]

Hi Brian, I have tried all these below and my value each time has been ZERO (0)

I have ran this in my database and answer should be 10

Do you see anything I am doing wrong (im thinking it can be a date format issue perhaps ?)

*** FAILED ATTEMPTS ***

COUNT({$<DELIVERY_DATE = {">04/12/2018"}>} ITEM_NAME)
COUNT({$<DELIVERY_DATE = {">04/12/2018"}>} ITEM_NAME)
COUNT({$<DELIVERY_DATE = {">'04/12/2018'"} >}ITEM_NAME)
COUNT({$<DELIVERY_DATE = {">'04/12/2018'"}>}[ITEM_NAME])
COUNT({$<DELIVERY_DATE = {">04/12/2018"}>}[ITEM_NAME])
COUNT({$<DELIVERY_DATE = {'>04/12/2018'}>}[ITEM_NAME])