Set Analysis Syntax - DATE

[brucejensen]

I need to sum my Cost field for all values in the set where the date field is prior to the current date. I tried the following but am not getting any results (evaluates to 0). Can someone help me with the syntax?

=sum({1<Date={"<=$(=DATE(MAX(Date)))"}>Cost)

I had this working at one point then lost it and now I can't get it to work again.

Thanks!

[#2]

Hi Bruce,

You're missing the closing } before Cost.

[MK_QSL]

=sum(

{1<

Date={"<=$(=DATE(MAX(Date)))"

}>}

Cost)

[#4]

Hi

see the below code and hopefully it will work out for your issue.

=sum(

{1<

Date={"<=$(=DATE(MAX(Date)))"

}>}

Cost) }

[brucejensen]

Sorry - Still not working. Still evaluates to 0.

[brucejensen]

Still comes up as zero for an answer.

[santharubban · Accepted solution]

try this

=sum({1<Date={'<=$(=DATE(MAX(Date)))'}>} Cost) }

[brucejensen]

Thanks!