SAP Analytics Cloud Planning Data Action Advance Formula

[pragi2028]

Hi all

using Data action I have to multiply a measure (percentage) which is stored under unassigned for all dimensions except for Cost center and Date with Salary of all employee

I have around 400 employee.

when i multiply it does not produce any result.

CONFIG.GENERATE_UNBOOKED_DATA=OFF
MEMBERSET[d/GL_Account]=("700102","800204","620401")
MEMBERSET[d/SAP_Cost_Center]=(BASEMEMBER([d/SAP_Cost_Center].[h/H1] ,"Cell Tech","Elec Tech","SG&A","Support OH" ))	

	DATA([d/Measures]="Benefit_Dollar",[d/Date]="202401") = RESULTLOOKUP([d/Measures]="Salary",[d/Date]="202401") *
	RESULTLOOKUP([d/Measures]="FICA_Medicare",[d/EE_ID]="#",[d/Date]="202401",[d/GL_Account]="#",[d/HR_Band]="#",[d/Job_Title]="#",[d/Name]="#",[d/Type]="#")​

Can someone please help with this. Any solutions.

Thanks in advance.

SAP Analytics Cloud SAP Analytics Cloud for planning 

[William_Yu]

Hi pragi2028, 

    The logic should be straight forward to achieve with advance formula.  I would suggest to recheck your code if all dimensions having '#' are specified in the second RESULTLOOKUP, for example 'Plan Year' . 

Best regards, William