Count days_between only if over >2 and show these days

[cbyrne]

Hello i have two data items below which counts the days between the two given dates, but now i need a seperate data item which counts or totals the days if >2 or >10.  I can get it to show a 0 or a 1 but not the actual days it has gone over.

Data item 1 = _days_between([Activity Complete Date],[Activity Received Date])

Data item 2 = _days_between([CIR End Date],[Activity Received Date])

Tried creating the below data item and it only created a 0 or 1.

COUNT (IF ([Rec to CIR Days]>2) THEN ( [Rec to CIR Days]) ELSE NULL for report)

Basically if the [Rec to CIR Days] is 4 days then i want to show 2 days as this is two days over.

Can this be done?


Many Thanks

Chris

[Lynn]

I have done that sort of thing and usually have to mess around a bit before I get it working!

You might try to create your new data item without the count function and use some key value instead of Rec to CIR Days. Then set the aggregate function for that item to count.

Code Select Expand

IF ( [Rec to CIR Days]>2 ) THEN ( [YourNamespace].[QSubject].[AccountNumber] ) ELSE ( NULL )

Otherwise the expression as you have it might be mis-behaving because the aggregate function isn't correct. Maybe try setting to None or Calculated?

[cbyrne]

Thanks Lynn, i will give it a try and let you know.


Chris