cancel
Showing results for 
Search instead for 
Did you mean: 

How to calculate % in SAC Dashboard

TanyaSrivastava
Participant
338

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.

StoresSalesAdmin expAdmin exp %Selling expSelling exp %
Store 110050 30 
Store 212030 35 
Store 311020 25 
Store 48010 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



 

View Entire Topic
N1kh1l
Active Contributor

@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.

N1kh1l_0-1718736350642.png

 

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

 

N1kh1l_2-1718736461099.png

Finally format this as %

N1kh1l_3-1718736616871.png

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

 

N1kh1l_5-1718736662303.png

Finally it should show up as % in the story

N1kh1l_6-1718736757705.png

Hope this helps !!

Nikhil

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