If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Show first date

Started by et21, 04 Oct 2023 05:11:00 PM

Previous topic - Next topic

et21

Hi all,

I have a question regardless of how to show only the first date that was enter in the report.

Eg: Project A: Updated on 12/05/2022
      Project A: Updated on 25/06/2022

I only want to show the first update 12/05/2022. Can someone please help me with that. TIA

MFGF

Quote from: et21 on 04 Oct 2023 05:11:00 PM
Hi all,

I have a question regardless of how to show only the first date that was enter in the report.

Eg: Project A: Updated on 12/05/2022
      Project A: Updated on 25/06/2022

I only want to show the first update 12/05/2022. Can someone please help me with that. TIA

Hi,

I assume this is the first date for each project?

Assuming you have a [Project] item and a [Date] item, you could add a detail filter to your report

[Date] = minimum([Date] for [Project])

Does this work for you?

Cheers!

MF.
Meep!

et21

Thank you MFGF, its working fine. I forgot that we can use minimum for that