Skip to Content
0
Former Member
May 20, 2015 at 07:53 AM

UJK_VALIDATION_EXCEPTION:Member "XXX" not exist

226 Views

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