Skip to Content
0
Aug 12, 2023 at 10:13 AM

SAP Analytic Cloud - Data Action

92 Views

Hi,

I have a below requirement where i need to allocate amount to the specific entity and costcenter combination based on the percentages. Below code is working with hardcoded values but i have to do this for many cc and entity combination. Please help how to acheive this without hardcoding.

DATA([d/Measures]="AMOUNT",[d/ENTITY]="1001",[d/COSTCENTER]="C1",[d/AUDIT_TRAIL="ALLOC")=

(RESULTLOOKUP([d/Measures]="AMOUNT",[d/AUDIT_TRAIL]="INPUT",[d/ENTITY]="1000",[d/COSTCENTER]="C01") *

RESULTLOOKUP([d/Measures]="PERCENTAGE",[d/AUDIT_TRAIL]="INPUT",[d/ENTITY]="1001",[d/COSTCENTER]="C02",[d/AUDIT_TRAIL]="PRECNT",) ))*12

image.png

Regards,

Lakshmi

Attachments

image.png (17.8 kB)