Project Count in Program Report | Community
Skip to main content
S
ShraddhaKh
September 21, 2021
Question

Project Count in Program Report

  • September 21, 2021
  • 3 replies
  • 1658 views

Hi,

I am trying to create a report where I can get a count of all projects on a program.

Thanks!

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    3 replies

    MoniqueEvans
    Community Advisor and Adobe Champion
    MoniqueEvansCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    September 22, 2021

    I'm hoping someone had been able to figure out the text mode for this column. @Shraddha Khedkar‚ and I are currently working on a Program Report and instead of showing the collection of Project Names, we would simply like to show the Project Count. I know we can reference task count in project reports so hoping to reference project count in program reports.

    It would also be great if there's a way for the count to SUM when grouped but not necessary.

    And yes, this has to stay as a Program Report for other functional purposes.

    Kundanism
    Kundanism
    Level 10
    September 22, 2021

    Hi @Shraddha Khedkar‚

    May be can try to create a project report, add Program Name in grouping. Also, can add company and project status type in filter.

    Mvh

    Kundan.

    Doug_Den_Hoed_AtAppStore
    Community Advisor
    Doug_Den_Hoed_AtAppStoreCommunity Advisor
    Community Advisor
    September 22, 2021

    Hi @Monique Evans‚,

    I'd suggest you use the DCNT function, as we did in a similar challenge to count Users on Projects, and resulted in the User Project Count package, which I invite you to deploy to your own environment as an example.

    Regards,

    Doug

    MoniqueEvans
    Community Advisor and Adobe Champion
    MoniqueEvansCommunity Advisor and Adobe Champion
    Community Advisor and Adobe Champion
    September 23, 2021

    Thanks Doug. I'll dig into this solution and see what magic we can make happen. Really was hoping for a quick text mode code we could drop in, or a program calc field. Hopefully Reporting 2.0 can easily solve this

      MoniqueEvans
      Community Advisor and Adobe Champion
      MoniqueEvansCommunity Advisor and Adobe Champion
      Community Advisor and Adobe Champion
      February 2, 2022

      Hey Sarah! Unfortunately, not yet. I have hope that the DCNT function could work but haven't had a chance to figure it out just yet. I was hoping that new reporting would be further along and could use that to solve.

        Terms & ConditionsAccessibility statement

        Loading footer...