Saved expressions
You can create saved expressions for use in custom reports. If you create your own saved expressions, you must save them to a Custom Subject Area that you have created to avoid losing them due to an upgrade. Upgrades and content updates will overwrite saved expressions if they are saved to an out-of-the-box provided custom subject area.
Infor-provided saved expressions include:
Consumer Space | Saved Expression | Definition |
---|---|---|
Read/Write:
Read Only:
|
Order By | IIF(GetPromptValue('Direction','Ascending')='Ascending', -1.0,1.0)*RANK(IIF(GetPromptValue('OrderBy')='Employee ID',[SECEMPTEAM_DIM.EMP_NAME],IIF(GetPromptValue('OrderBy')='Last Name',[SECEMPTEAM_DIM.EMP_LASTNAME],IIF(GetPromptValue('OrderBy')='First Name',[SECEMPTEAM_DIM.EMP_FIRSTNAME],'0')))) |
Read/Write:
Read Only:
|
WAROT | IIF( [HOURTYPE_DIM.HTYPE_NAME]='OT1' or [HOURTYPE_DIM.HTYPE_NAME]='OT1.5', [Sum: WAR_WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
OVERTIMEMINUTES | IIF([HOURTYPE_DIM.HTYPE_RPT_ISOT] = 'Y', [Sum: WRKD_MINUTES],0) |
Read/Write:
Read Only:
|
PRODUCTIVEMINUTES | IIF([TIMECODE_DIM.TCODE_RPT_ISPRDCTV] = 'Y', [Sum: WRKD_MINUTES],0) |
Read/Write:
Read Only:
|
DT | IIF( [HOURTYPE_DIM.HTYPE_NAME]='OT2' or [HOURTYPE_DIM.HTYPE_NAME]='OT2.0', [Sum: WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
Start Date | iif(Getpromptvalue('Date Selection','Manual Date')='Current Schedule Period', FORMAT([WBI_TEAM_SCHPRD_DATE.WTSD_CURRENT_START],'MM/dd/yyyy'), iif(Getpromptvalue('Date Selection','Manual Date')='Previous Schedule Period',FORMAT([WBI_TEAM_SCHPRD_DATE.WTSD_PREV_START],'MM/dd/yyyy'), iif(Getpromptvalue('Date Selection','Manual Date')='Next Schedule Period', FORMAT([WBI_TEAM_SCHPRD_DATE.WTSD_NEXT_START],'MM/dd/yyyy'), FORMAT(Datetime(Getpromptvalue('StartDate')),'MM/dd/yyyy')))) |
Read/Write:
Read Only:
|
Non Productive Hours | [Sum: WRKD_HOURS]-SavedExpression('PRODUCTIVEHOURS') |
Read/Write:
Read Only:
|
ASSIGNED | IIF(GetPromptValue('WorkingHours', 'No')='Yes' AND [ACTIVITY_DIM.ACT_WORKING] = 'N',0, [Sum: SCHEDULED_HOURS]) |
Read/Write:
Read Only:
|
WARTOTALPAIDTIME | IIF( [HOURTYPE_DIM.HTYPE_NAME]='REG', [Sum: WAR_WRKD_MINUTES]/60,0)+IIF( [HOURTYPE_DIM.HTYPE_NAME]='OT1' or [HOURTYPE_DIM.HTYPE_NAME]='OT1.5', [Sum: WAR_WRKD_MINUTES]/60,0)+IIF( [HOURTYPE_DIM.HTYPE_NAME]='OT2' or [HOURTYPE_DIM.HTYPE_NAME]='OT2.0', [Sum: WAR_WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
WARREG | IIF( [HOURTYPE_DIM.HTYPE_NAME]='REG', [Sum: WAR_WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
TOTALUNPAIDTIME | IIF( [HOURTYPE_DIM.HTYPE_MULTIPLE]<=0, [Sum: WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
OT | IIF( [HOURTYPE_DIM.HTYPE_NAME]='OT1' or [HOURTYPE_DIM.HTYPE_NAME]='OT1.5', [Sum: WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
ABSENTMINUTES | IIF([TIMECODE_DIM.TCODE_IS_LTA] = 'Y', [Sum: WRKD_MINUTES],0) |
Read/Write:
Read Only:
|
OVERTIMEHOURS | IIF([HOURTYPE_DIM.HTYPE_RPT_ISOT] = 'Y', [Sum: WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
TOTALPAIDTIME | IIF( [HOURTYPE_DIM.HTYPE_NAME]='REG', [Sum: WRKD_MINUTES]/60,0)+IIF( [HOURTYPE_DIM.HTYPE_NAME]='OT1' or [HOURTYPE_DIM.HTYPE_NAME]='OT1.5', [Sum: WRKD_MINUTES]/60,0)+IIF( [HOURTYPE_DIM.HTYPE_NAME]='OT2' or [HOURTYPE_DIM.HTYPE_NAME]='OT2.0', [Sum: WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
EXCEPTIONMINUTES | IIF([TIMECODE_DIM.TCODE_IRREGULAR] = 'Y', [Sum: WRKD_MINUTES],0) |
Read/Write:
Read Only:
|
ABSENTHOURS | IIF([TIMECODE_DIM.TCODE_IS_LTA] = 'Y', [Sum: WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
WARTOTALUNPAIDTIME | IIF( [HOURTYPE_DIM.HTYPE_MULTIPLE]<=0, [Sum: WAR_WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
LOSTHOURS | IIF([TIMECODE_DIM.TCODE_IS_LTA] = 'Y', [Sum: WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
WARDT | IIF( [HOURTYPE_DIM.HTYPE_NAME]='OT2' or [HOURTYPE_DIM.HTYPE_NAME]='OT2.0', [Sum: WAR_WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
WRKD AVG HOURLY RATE | IIF([HOURTYPE_DIM.HTYPE_MULTIPLE]>0, [Sum: WRKD_RATE],0) |
Read/Write:
Read Only:
|
EXCEPTIONHOURS | IIF([TIMECODE_DIM.TCODE_IRREGULAR] = 'Y', [Sum: WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
DateDifference | DateDiff(Day,#1900-01-02#,#1900-01-01#) |
Read/Write:
Read Only:
|
End Date | iif(Getpromptvalue('Date Selection','Manual Date')='Current Schedule Period', FORMAT([WBI_TEAM_SCHPRD_DATE.WTSD_CURRENT_END],'MM/dd/yyyy'), iif(Getpromptvalue('Date Selection','Manual Date')='Previous Schedule Period',FORMAT([WBI_TEAM_SCHPRD_DATE.WTSD_PREV_END],'MM/dd/yyyy'), iif(Getpromptvalue('Date Selection','Manual Date')='Next Schedule Period', FORMAT([WBI_TEAM_SCHPRD_DATE.WTSD_NEXT_END],'MM/dd/yyyy'), FORMAT(Datetime(Getpromptvalue('EndDate1')),'MM/dd/yyyy')))) |
Read/Write:
Read Only:
|
REG | IIF( [HOURTYPE_DIM.HTYPE_NAME]='REG', [Sum: WRKD_MINUTES]/60,0) |
Read/Write:
Read Only:
|
PRODUCTIVEHOURS | IIF([TIMECODE_DIM.TCODE_RPT_ISPRDCTV] = 'Y', [Sum: WRKD_MINUTES]/60,0) |