The Siemens Community Catalyst program was co-created with our community to acknowledge technology leaders who consistently contribute to the Siemens Community. Nominations are accepted on a rolling basis.
Hi, I am trying to figure out how to write a formula based on between two numbers in a balance category. I need to balance total and also number of accounts total. I am not sure how to exactly write this. Any help would be appreciated.
Hi Angela,
I may need a screen shot showing how the data appears and what your desired results are to give a full answer.
However, if this is a rolling balance over multiple records, then the Transform->Group may do what you need.
From a table like this . . .
Select Transform->Group, and define it like this . . .
After renaming the fields, you should have a table like this . . .
Please let me know if this is close, or feel free to provide more details and I'll try again!
Regards,
Steve.
EDIT - I guess Opening Balance would really be zero in this simple example, but the specific options would depend on your starting data.
Join us for a Community Conversation where we'll discuss practical approaches to analyzing complex electromagnetic models using hybrid solver techniques. This session will provide a general overview of how different computational methods can be combined within a single simulation to address models containing varied…
Join us for a community conversation to explore how different modeling approaches in Simcenter PSIM can help engineers simulate power electronics systems while balancing accuracy, simulation speed, and design insight. What you'll learn: Power transistor modeling : Thermal and high fidelity models Protection component…