jCell/jCellN()

Estimated reading time: 3 minutes

Function Summary

jCell retrieves data based on the provided parameters. The first argument is typically a jAcct() lookup when a company has more than one segment to filter. The retrieved data is always summarized into a single value.

Filter text for up to six segments of a chart of accounts. Use the INTERJECT function jAcct() when more than a single segment is used as a filter.

Function Arguments

Parameter Name Description Default Optional
Full Account Filter text for up to six segments of a chart of accounts. Use the INTERJECT function jAcct() when more than a single segment is used as a filter.   NO
Period The month or quarter to filter the retrieved data.   YES
Year The year or range of years to filter the retrieved data.   YES
Source A source filter that may include budget, actual, or forecast, depending on user’s system.   YES
Version Filters the retrieved data.   YES
Company Sub-grouping to retrieve data only from a specific company or district.   YES
Currency     YES

Excel Formula Bar Example

=jCellN(jAcct("Revenue - Sales",7002),11,2001,Actual)

An example of this function is currently in construction in our documentation labs. Check back soon for an example with more context. However, for a demo report using this feature, visit the Epicor Demo in the report Library and open the file PL Trend - w/ DataCells.

Function Composition

Argument Name Example Mapping Explanation
Function Name jCellN() The name of the report formula.
Full Account jAcct(“Revenue - Sales”,7002) Which account the data is accessing based on the jAcct() filter.
Period 11 Accessing the 11th period of that year to filter down further.
Year 2001 The year of which the data is from.
Source “Actuals” Looking at Actuals specifically from the period and year specified.
Version    
Company    
Currency