Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.
Hi!
='Current No of Errors
' &Round(count({<HIST_DATE_DTTM_DAY={'$=(date(Today()))'}>}HIST_TOTAL),1)
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.
Hi Swuehl,
This seems to work well.
Thank You