Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two fields in my table Date
& ID
, i want to put in a text box the count of all the ids for the last 12 months.
This returns nothing:
=Num(count({$<DATE={'>=$(=AddMonths(Today(),-12))'}>}[ID]),'#,##0')
This returns the correct count:
=count(ID)
This returns the total for the year (2015):
SUM(IF( year(DATE) = year(today()),1,0))
This worked
=SUM(IF( (date(Monthname(DATE),'MMM-YY')) >=(AddMonths(Today(),-12)),1,0))
Hi,
=Num(count({$<DATE={">=$(=AddMonths(Today(),-12))"}>}[ID]),'#,##0')
Regards,
Prashant
See if this works:
=Count({<DATE = {"$(='>=' & Date(AddMonths(Max(DATE), -12), 'YourDateFieldFormat') & '<=' & Date(Max(DATE), 'YourDateFieldFormat'))"}>} ID)
Try this:
=Num(count({1<DATE={'>=$(=AddMonths(Today(),-12))'}>}[ID]),'#,##0')
=Num(count({1<DATE={'>=$(=AddMonths(Today(),-12))'}>} ID),'#,##0')
This worked
=SUM(IF( (date(Monthname(DATE),'MMM-YY')) >=(AddMonths(Today(),-12)),1,0))