How to calculate % in SAC Dashboard

[TanyaSrivastava]

Hi All,

In SAP Analytics Cloud (SAC) Dashboard, we have a requirement to showcase % of each GL heads in our story.

Below is the example, We have multiple Stores as Store 1, Store2, etc, and against it Sales & expense has been booked.

Stores	Sales	Admin exp	Admin exp %	Selling exp	Selling exp %
Store 1	100	50		30
Store 2	120	30		35
Store 3	110	20		25
Store 4	80	10		30

Now we want to display the % of expense against the Sale.
Admin exp % = Admin exp/Sales * 100
Selling exp % = Selling exp/Sales * 100

How can we achieve this in SAC?

Regards,
Tanya Srivastava

• SAP Analytics Cloud,
• SAP Analytics Cloud for planning,
• SAP Analytics Cloud, augmented analytics,
• SAP Analytics Cloud, hybrid analytics,
• SAP Analytics Cloud, add-in for Microsoft Office,
• SAP Allocation and Rescheduling Optimization,
• SAP ERP, add-on for embedded production planning and detailed scheduling,
• SAP S/4HANA Finance, FIN Controlling

[N1kh1l]

@TanyaSrivastava 

You have already put up the formula 

Admin exp % = Admin exp/Sales 
Selling exp % = Selling exp/Sales 

Just create calculated account /measures in the story depending on whether Sales, Admin Exp are accounts or measures.

Define the formula as below. Once your press [   you will start seeing your original accounts/measures.

Finally format this as %

Uncheck Use unit of underlying measures and then set it as %

Finally it should show up as % in the story

Hope this helps !!

Nikhil

[TanyaSrivastava]

Hi Nikhil,

[TanyaSrivastava]

Hi Nikhil, Does it mean i have to write separate formula for each head, as there 15+ heads similar to Admin Exp.

[TanyaSrivastava]

Hi @N1kh1l ,

Does this mean I need to create a formula for every head in my story (there are 15+ heads)? Additionally, each head has multiple GL accounts under it, forming a hierarchy. How can the formula be calculated at the lower levels of this hierarchy?

Regards,
Tanya