Hi,
I am looking for logic to calulate the below requirement.
Employee dimension has property NO_DAYS(used to capture no of days employee work in year)
I need to calculate effective FTE
Effective FTE = NO_DAYS/365
Example: NO_DAYS = 182
Effective FTE = 182/365 = 1/2 = 0.50 FTE.
I want to use script logic for calculation.
*WHEN EMPLOYEE
*IS *
*REC(EXPRESSION = %VALUE%*([EMPLOYEE].[NO_DAYS])/365)
*ENDWHEN
I am getting this error
UJK_VALIDATION_EXCEPTION:Member "NO_DAYS" not exist
Hi,
"Employee dimension has property NO_DAYS" - it's a bad idea to use property to store some value. You can't use it in the REC expression directly, only using slow FOR/NEXT!
Simply create some account NO_DAYS and fill it with the required values. Then use this account in script logic calculations.
Vadim
Hi,
I think you are missing select statement to read attribute of Employee.
Thanks,
Raju
Add a comment