The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Solved
UD8 Dynamic Calc - Aggregate Entities
Hello - Is there a way to have a Ud8 dynamic calc sum up certain entities based on a text field? I am trying to tag a text field on certain entities and have a dynamic calc aggregate the entities bas...
I am on the same team. I found the solution here:
https://community.onestreamsoftware.com/t5/Office-Hours/Question-Is-there-a-way-to-report-the-total-of-a-group-of/ta-p/1268Thank you Partner Enablement Team for this post. It is a very helpful and very, very educational solution!
You will need to loop through the desired list of members that was derived with an appropriate where Text Contains abc clause. Within the loop, get the data cell you want for the entity, and accumulate that to a running total.