Issue with script logic(HR related calc)

Hello Friends,

I am trying to do some calculations on FICA, it basically has the logic that looks up fica salary limit(statistical account) and fica rate(also stat account) and as long as the YTD salary is less than fica salary limit it should calculate. I have already searched through the forum for solution as well. Here is my code:

*WHEN HR_ACCT

*IS AC_611000 COMMENT - THIS IS THE SALARY ACCOUNT

*WHEN MEASURES

*IS YTD

*REC(EXPRESSION=(%VALUE%<([HR_ACCT].[FICA_LIMIT],[EMPLOYEE].[No_employee])?(%VALUE%*([HR_ACCT].[FICA_RATE],[EMPLOYEE].[No_employee])):0),HR_ACCT=AC_611080)

*ENDWHEN

*ENDWHEN

*COMMIT

This code almost works. the only issue is %VALUE% it brings is periodic not ytd. I have tried to use lookup/endlookup as well to bring ytd value, that wont work either. Any suggestions?thanks.