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 on how High-Performance Computing (HPC) and Simcenter PSIM work together to meet the increasing demands of modern power electronics simulation. During this one-hour technical session, you'll discover how leveraging HPC can speed up simulations, improve scalability, and empower engineers…
Join us for a community conversation on accelerating your motor simulation workflow with Simcenter Simlab. In this beginner-friendly session, we'll introduce the platform's automated model-building capabilities and show how easy it is to set up your first electric motor analysis. You'll see the basic steps of geometry…
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…
