Text Box Count

[Anonymous]

Hi Guys,

I have the below expression In a Text Box. Basically I only want to count the HIST_TOTAL (Total Number of Errors) where the HIST_DATE_DTTM_DAY  = Todays Date. HIST_TOTAL has errors from numerous dates but I just want my expression to count the latest date.   I've tried to use the Today() function in the expression but it doesn't seem to be working.

='Current No of Errors
' &Round(count({<HIST_DATE_DTTM_DAY={Today}>}HIST_TOTAL)) 

I'm sure this is simple to resolve so any suggestions would be great.

Cheers,

[pokassov]

Hi!

='Current No of Errors
' &Round(count({<HIST_DATE_DTTM_DAY={'$=(date(Today()))'}>}HIST_TOTAL),1)

[swuehl · Accepted solution]

Try

='Current No of Errors
' &Round(count({<HIST_DATE_DTTM_DAY={'$(=Today())'}>} HIST_TOTAL))

Assuming that HIST_DATE_DTTM_DAY shows dates in default date format.

[Anonymous]

Hi Swuehl,

This seems to work well.

Thank You