I have searched the threads for an answer because I know this question has been asked before. I was not able to find what I needed.
I'm performing some datediff math in a group header and this works perfectly:
ELAPSED DAYS:
if isnull({Sheet1_.Next Assessment Date}) then 30 else
(DateDiff ("d",Minimum ({@Next Assessment Date}, {Sheet1_.Legal Name}) , Maximum ({Sheet1_.Date Reported}, {Sheet1_.Legal Name})))
The next step is to average Elapsed Days in the Report Header. I added @Elapsed Days to a table to get an average. The results are close, but not correct.
Any ideas? Thank you.
I'm performing some datediff math in a group header and this works perfectly:
ELAPSED DAYS:
if isnull({Sheet1_.Next Assessment Date}) then 30 else
(DateDiff ("d",Minimum ({@Next Assessment Date}, {Sheet1_.Legal Name}) , Maximum ({Sheet1_.Date Reported}, {Sheet1_.Legal Name})))
The next step is to average Elapsed Days in the Report Header. I added @Elapsed Days to a table to get an average. The results are close, but not correct.
Any ideas? Thank you.