2 weeks ago - last edited 2 weeks ago
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
8 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.