3 Replies Latest reply: Nov 6, 2017 5:53 PM by Luis Madriz RSS

    Aggregate values instead recalculate up a hierarchy

    Neil Gabin

      I have a 3 level hierarchy (3 related fields); Region, Role and Worker


      I'm calculating the number of work days for each Worker at the lowest level and this is correct.


      Is it possible to aggregate these calculated values and not have the formula reapplied and recalculated at the higher levels of Role and Region


      vFirstSelectedPeriod = min([Period])

      vLastSelectedPeriod = max([Period])

      vWorkDays = NetWorkDays($(vFirstSelectedPeriod), $(vLastSelectedPeriod))