Calculating values only if date1 > date2 using set anlysys

[fishmanl]

Hi

lets say i have the attached table, and i want to sum only values when date2 is greater than date1 - marked in yellow

i don't want to use IF statement, instead i would like to do it with Set Analysis, i use the following and it didn't work:

=Sum( {<date1={">$(=MIN(date2))"}>} cost)

what im doing wrong?

[AshutoshBhumkar · Accepted solution]

Hello,

Try below,

Sum({<Cost = {"=Date2>=Date1"}>}Cost)

Hope this helps.

Thanks,
Ashutosh

[fishmanl]

hi

working great!

but why the modifier is cost? shouldn't it be date1 vs date2?

[AshutoshBhumkar]

We are taking only cost line items where Date2 is greater than Date1