Hi Folks,
I have a report with a single table [EVENTS] using the same date field but with differing filter criteria.
[ACTUAL DATE] filtering on [EVENT CODE]
The goal is to calculate the interval of [ACTUAL DATE] between two differing event codes.
So as follows:
CALC 1: CASE WHEN([EVENT_D].[EVENT_CODE] = 'SR191') THEN ([EVENT_D].[ACTUAL_DATE]) ELSE NULL END
CALC 2: CASE WHEN([EVENT_D].[EVENT_CODE] = 'SR192') THEN ([EVENT_D].[ACTUAL_DATE]) ELSE NULL END
INTERVAL CALC = CALC1 - CALC2
The report splits the two dates onto separate lines in RS, and no result is returned for the interval.
Is there a way to bring back both CALC1 & CALC2 to the same row?
Or at least achieve a result for the interval? (The two dates do not need to be on the report, only the interval is required.
Even in Framework Manager, the interval calc has no result.
Much appreciated,
Locus
Try setting the aggregation method on each of your calc columns to maximum.
Aaargh! So simple! :o
Thanks Lynn :D Works great
Yay! It is always easier once you know the answer ;D