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

Regards,
Lakshmi