Skip to main content
maura-k
Level 3
August 10, 2022
Question

Program report pulling number of Projects in Program

I have been trying to figure out how to create a Program report that pulls the number of Projects. I have found how to filter to show empty Programs but I can't find a way to pull the number of Projects in a Program. Does anyone have the text mode for how to pull that?

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

    5 replies

    Kurt_Jones
    Adobe Champion, Community Advisor, UG Leader
    Kurt_JonesAdobe Champion, Community Advisor, UG Leader
    Adobe Champion, Community Advisor, UG Leader
    August 10, 2022

    Maura, this will give you the listing of projects underneath each Program, I think that is what you were looking for.  I'm not sure you can just get a sum (number) of this or if so I'm not sure how to do it 😞

     

    displayname=Projects
    listdelimiter=<p>
    listmethod=nested(projects).lists
    textmode=true
    type=iterate
    valuefield=name
    valueformat=HTML

    Translate
    If my response answered your question, please mark it answered, so others can find the answer
      maura-kAuthor
      Level 3
      August 10, 2022

      That worked for my use case, probably even better than just giving me a number too! Thanks for the help!!

      Translate
      J_Hobbs
      Level 3
      January 13, 2025

      That code is quite handy and should be built into the tool based on it being relevant and useful data to include when looking at Programs.

      Translate
      Stacey_Robertson
      Level 6
      August 10, 2022

      I'm not sure if you use fusion - I have fusion count the projects under each portfolio or program and add it to a field on our custom form and then we can report on that number.

      Translate
        maura-kAuthor
        Level 3
        August 10, 2022

        Ohh we do have Fusion. That's a good idea - I can think of a few other things to with that too! Thanks!!

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...