DBO.EQ_STD_COST_ESTIMATE_LINE_ITEM_VALUE_GET(Parameter1, Parameter2, Parameter3)
This function will retrieve an annualized line item value from any cost estimate or compensation calculation. It can be used in any user report, regardless of the tables included in the report type. This is especially useful when building data sources for merge documents and is also very useful when transferring numbers between a series of Cost Estimates (CE) or Custom Calculations (CC). The CE or CC Line Item table can be left out of the Report Type which means there is less need to aggregate down from a large amount of data.
Parameter(s)
Parameter1: The Cost Estimate or Compensation Calculation ID
Parameter2: The Line Item Name
Parameter3: The currency you wish to return the value in (Home, Host, System, Company, Data Entry)
Example(s)
Example 1: Returns the annualized amount of the line item value of the specified record.
DBO.EQ_STD_COST_ESTIMATE_LINE_ITEM_VALUE_GET(431,'Annual Gross Base Salary','Data Entry')