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.
I have four payment columns that I want to calculate the total per a patient account number.
If in excel, I would use =sum(Pymt1+Pymt2+Pymt3+Pymt4)
Even in the Summary process, only get totals for the column and not as a row/attribute.
Thank you!
Depending on how your data is displayed, you have a couple of options.
Sounds like you already have the payment columns created. You can simply create a new formula column to add those columns up by clicking on the menu drop down arrow of any column and selecting Column->New Formula Column...:In the "New Formula Column" wizard, give your new column a name and then start building your expression by double clicking on the columns you want to add. Place a plus key (+) in between each column:And then press the OK key.
If the data is not grouped by patient account number, try using Transform->Group (Group and summarize values) and group your data on patient account number and then use the above suggestion.
If your payment columns are not created yet, you can try either using Transform->Pivot to create them.
If this doesn't answer your question, is it possible to share a screenshot or an example of the data so we can better understand how your data is displayed?
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…
