Aggregate values instead recalculate up a hierarchy

[Anonymous]

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))

[sunny_talwar · Accepted solution]

May be this

Sum(Aggr(NetWorkDays($(vFirstSelectedPeriod), $(vLastSelectedPeriod)), Region, Role, Worker))

[Anonymous]

thank so much. this is such a useful channel for "newbies" like me.

[luismadriz]

Nicely explained Neil!

With explanations like this you'll get the attention of the gurus such as Sunny. I still haven't fully grasped Aggr but I'll get there...

Cheers,

Luis