Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to write this logic in set analysis
if(Date <= '2014-01-31',sum(amount))
kindly help
SUM({<Date = {'<=$(=MonthEnd(YearStart(Today())))'}>}Amount)
Try like:
=Sum({<Date={" <= 2014-01-31"}>}amount)
Hi,
Try this. Hope it works...
sum ({$<Date<={'2014-01-31'}>} amount)
Sum( {< Date = { "=2014-01-31"> amount) ..
Hope this helps