cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Analytics Cloud Planning Data Action Advance Formula

pragi2028
Explorer
0 Kudos

Hi all ,

I have a requirement where a certain percentage of amount for certain cost center should detected and get stored to a GL called Direct. For example refer below amount 2000 from Cost center 101 where 10% ie. 200 must get allocated to Direct. How can I perform this using Advanced formula in Data Action

pragi2028_1-1712747284216.png

 

 

Thanks!! in advance

SAP Analytics Cloud SAP Analytics Cloud for planning 

 

View Entire Topic
N1kh1l
Active Contributor
0 Kudos

@pragi2028 

The solution will depend on whether the percentage of DIRECT deduction is based on Cost center or Costcenter and GL combination. If it is just based on costcenter you can maintain these percentages in property ( type number) of costcenter and use it in DA. If its based on Costcenter and GL then you need to maintain these percentages in system at CC and GL combination and may be other dimension as #.

First approach:

 

MEMBERSET [D/Account]=("A","B","C","D","E")

DATA([d/Account]="Direct") = ATTRIBUTE([d/costcenter].[p/directperc])*RESULTLOOKUP()

 Second Approach

MEMBERSET [D/Account]=("A","B","C","D","E")
DATA([d/Account]="Direct") = RESULTLOOKUP([Account]="DirectPerc") * RESULTLOOKUP()

In RESULTLOOKUP([Account]="DirectPerc") please specify all other dimension as # if you use them to store the percentages.

 

Hope this helps !!

Nikhil