<p>about your learning experience to help us improve.</p>

You've completed

cleanFiles/bookmap_Pointing_out_Advanced_SAP_Analytics_Cloud__en-US_learning-sap-com_lsc-prod.zip (MMCP-DROPZONE) - 2024-10-17T12:22:33.000Z

Working with Formulas in Tables

<div id="content"><div class="parentsection"><div class="section"><div tabindex="0"><h3>Is it possible to add custom formulas to my table to, for example, sum values or perform more advanced calculations based on my data rows and columns? Can I use predefined client calculations for even faster analysis?</h3></div><p tabindex="0">Adding columns, rows, and predefined client calculations to your existing table is possible by right-clicking on a dimension member and selecting the desired action. You can create formulas and calculations tailored to your preferences.</p><p tabindex="0">The following video provides a comprehensive answer to your question.</p><div class="kalturaVideoLessonWrapper"><div aria-label="" class="kalturaVideoLessonContainer" data-testid="video" id="1_pgy0alm2"></div></div></div></div></div>

Formulas in Tables

Answering Frequently Asked Questions for SAP Analytics Cloud for the Sports Industry

<div>Learn how to create custom columns and tables, work with formulas, and optimize data presentation in SAC for enhanced analytics. Enhance your data analysis skills with practical examples and step-by-step guidance.<br><br># This description was auto-generated #</div>

In addition to using the predefined model measures in SAC, you can also create custom columns and tables and work with formulas. For example, let's take a look at a player's minutes played per match day. To add a new column, right-click on the header of the existing measure located to the left of where you want to insert the new column. Select Add Column and choose either Repeating or Single. The Repeating option adds a column for each recurrence of a dimension member, while the single option adds one column for the combined dimension members. This allows you to differentiate between displaying the percentage playtime for each match day or the average playtime over the entire time range. For this example we will choose the repeating option. After creating a new column select the header cell and start inserting your formula. In this example we will calculate the percentage of match playtime for the player per match day using two existing measures already depicted in the table. Once the formula is entered, the cells in the new column will be filled automatically. Additionally, ensure you name the header cell of the new column. Adding a formula to a table generates a new calculation named after the header cell we recently designated. Like the predefined model calculations, this formula is displayed in the table column as a selectable measure. As with model calculations, you can adjust the formulas formatting. In this example, we'll convert the values to a percentage scale with no decimal places. Additionally, you can perform other operations with this calculation, such as adding an in-cell chart to this column or inserting a threshold. In addition to adding individual formulas to your table, you can also add predefined client calculations as a new column. To do this, click on the header cell of an existing calculation and select Add Client Calculation. You will then see an overview of various client calculations to choose from, such as moving averages, ranks, minimum and maximum values, or totals. In this example, we'll select the average option. A new column has been created in the table. This column displays the moving average of the player's minutes played. Note that, in addition to adding formulas and client calculations for columns, you can also add them for rows. For instance, you might wanna display the total sum of all rows at the bottom of your table.