set analysis Logic

[abhaysingh]

I want to write this logic in set analysis

if(Date <= '2014-01-31',sum(amount))

kindly help

[MK_QSL]

SUM({<Date = {'<=$(=MonthEnd(YearStart(Today())))'}>}Amount)

[tresesco]

Try like:

=Sum({<Date={" <= 2014-01-31"}>}amount)

[#4]

Hi,

Try this. Hope it works...

sum ({$<Date<={'2014-01-31'}>} amount)

[ychaitanya]

Sum( {< Date = { "=2014-01-31"> amount) ..

Hope this helps