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
