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: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	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: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	WAROT	IIF( [HOURTYPE_DIM.HTYPE_NAME]='OT1' or [HOURTYPE_DIM.HTYPE_NAME]='OT1.5', [Sum: WAR_WRKD_MINUTES]/60,0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	OVERTIMEMINUTES	IIF([HOURTYPE_DIM.HTYPE_RPT_ISOT] = 'Y', [Sum: WRKD_MINUTES],0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	PRODUCTIVEMINUTES	IIF([TIMECODE_DIM.TCODE_RPT_ISPRDCTV] = 'Y', [Sum: WRKD_MINUTES],0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	DT	IIF( [HOURTYPE_DIM.HTYPE_NAME]='OT2' or [HOURTYPE_DIM.HTYPE_NAME]='OT2.0', [Sum: WRKD_MINUTES]/60,0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	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: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	Non Productive Hours	[Sum: WRKD_HOURS]-SavedExpression('PRODUCTIVEHOURS')
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	ASSIGNED	IIF(GetPromptValue('WorkingHours', 'No')='Yes' AND [ACTIVITY_DIM.ACT_WORKING] = 'N',0, [Sum: SCHEDULED_HOURS])
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	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: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	WARREG	IIF( [HOURTYPE_DIM.HTYPE_NAME]='REG', [Sum: WAR_WRKD_MINUTES]/60,0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	TOTALUNPAIDTIME	IIF( [HOURTYPE_DIM.HTYPE_MULTIPLE]<=0, [Sum: WRKD_MINUTES]/60,0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	OT	IIF( [HOURTYPE_DIM.HTYPE_NAME]='OT1' or [HOURTYPE_DIM.HTYPE_NAME]='OT1.5', [Sum: WRKD_MINUTES]/60,0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	ABSENTMINUTES	IIF([TIMECODE_DIM.TCODE_IS_LTA] = 'Y', [Sum: WRKD_MINUTES],0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	OVERTIMEHOURS	IIF([HOURTYPE_DIM.HTYPE_RPT_ISOT] = 'Y', [Sum: WRKD_MINUTES]/60,0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	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: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	EXCEPTIONMINUTES	IIF([TIMECODE_DIM.TCODE_IRREGULAR] = 'Y', [Sum: WRKD_MINUTES],0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	ABSENTHOURS	IIF([TIMECODE_DIM.TCODE_IS_LTA] = 'Y', [Sum: WRKD_MINUTES]/60,0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	WARTOTALUNPAIDTIME	IIF( [HOURTYPE_DIM.HTYPE_MULTIPLE]<=0, [Sum: WAR_WRKD_MINUTES]/60,0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	LOSTHOURS	IIF([TIMECODE_DIM.TCODE_IS_LTA] = 'Y', [Sum: WRKD_MINUTES]/60,0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	WARDT	IIF( [HOURTYPE_DIM.HTYPE_NAME]='OT2' or [HOURTYPE_DIM.HTYPE_NAME]='OT2.0', [Sum: WAR_WRKD_MINUTES]/60,0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	WRKD AVG HOURLY RATE	IIF([HOURTYPE_DIM.HTYPE_MULTIPLE]>0, [Sum: WRKD_RATE],0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	EXCEPTIONHOURS	IIF([TIMECODE_DIM.TCODE_IRREGULAR] = 'Y', [Sum: WRKD_MINUTES]/60,0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	DateDifference	DateDiff(Day,#1900-01-02#,#1900-01-01#)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	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: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	REG	IIF( [HOURTYPE_DIM.HTYPE_NAME]='REG', [Sum: WRKD_MINUTES]/60,0)
Read/Write: {TENANT_NAME}-WFMOP-MT-Consumer {TENANT_NAME}-WFMOP-MT-Model Read Only: {TENANT_NAME}-SMD-WFMOP-MT-Consumer {TENANT_NAME}-SMD-WFMOP-MT-Model	PRODUCTIVEHOURS	IIF([TIMECODE_DIM.TCODE_RPT_ISPRDCTV] = 'Y', [Sum: WRKD_MINUTES]/60,0)