Calculated field that adds up points from multiple requests | Community
Skip to main content
T
TraKill
Level 3
May 28, 2025
Solved

Calculated field that adds up points from multiple requests

  • May 28, 2025
  • 1 reply
  • 784 views

Hi Community,

We have a request queue with a calculated field adding certain capacity points for certain requests:

1. Creating New content for Sprint x has 2 points
2. Updating existing content for Sprint x has 1 point
3. Re-using existing content for Sprint x has 0 points.

How do I set up a calculated field, that is adding up all the calculated fields from all incoming requests into one field to determine the capacity for sprint x?

Thanks in advance

Best answer by skyehansen

Okay, since a colleague built it and we already have a few fusion scenarios built I am not sure if we can change it by now, but if this is the only chance in order to get the calculation it is worth asking. Thank you!


I don't think there's an urgent need to remove the existing calculation at this time. Just create a new calculated field and see if it does what you want. If it does, you can assess and make a plan to replace the old field at that time.

1 reply

skyehansen
Community Advisor
skyehansenCommunity Advisor
Community Advisor
May 28, 2025

there's not really a way to do this. Calculated fields stay within that one object so you can't look around outside your object and then start adding from these other objects. The closest you would get would be a report on the objects, aggregating (summing) on that field.

    T
    TraKillAuthor
    Level 3
    May 28, 2025

    That would work!
    Currently the only issue is with summing those up, that my reporting is counting by incoming request. I already excluded the 0 counts, but the 2s are not multiplied by request type 2. 😕😕

    skyehansen
    Community Advisor
    skyehansenCommunity AdvisorAccepted solution
    Community Advisor
    May 29, 2025

    Okay, since a colleague built it and we already have a few fusion scenarios built I am not sure if we can change it by now, but if this is the only chance in order to get the calculation it is worth asking. Thank you!


    I don't think there's an urgent need to remove the existing calculation at this time. Just create a new calculated field and see if it does what you want. If it does, you can assess and make a plan to replace the old field at that time.

      Terms & ConditionsAccessibility statement

      Loading footer...