Age Count

[Former Member]

Hi,

In my report i have the following fields, Issued_DT and Current_DT, which I am going to use to calculate the Age (Current_DT - Issued_DT). Issued_DT is of type replacement path and Current_DT is the current run date being populated using a customer exit. I want to calculate a count on the Age where it fits an interval < 14 days, and do not want Issued_DT in the drilldown, but have the count sum by another characteristic.Whenever the Issued_DT is not in the drilldown the Age calculation becomes X. Is there any way around this?

[Former Member]

Hi,

Since Issue_DT is being used for replacement path, it is required in drilldown - how would the system replace it otherwise?

If you don't want to show it in the output, simplest way would be to specify 'no display' in its properties in the query designer.