This function gets the mean value for values other than NULL. You can use a result of the Array function as a parameter.
AVG(Balances.Quantity)
Next page: ARRAY- NEW! COVID-19 Community response
- Hello, 1C
- Training Course - Junior Developer level
- Practical developer guide 8.3
- Overview
- Lesson 1 (0:40). Introduction. Creating an infobase
- Lesson 2 (0:45). Subsystems
- Lesson 3 (2:10). Catalogs
- Lesson 4 (1:30). Documents
- Lesson 5 (2:00). Theory
- Default forms
- Event handlers
- Modules
- A form as a script object
- Event handler procedures in form modules
- Understanding form module content
- Understanding 1C:Enterprise script
- Objects, objects, objects
- Server and clients
- Common module compilation
- Compilation directives
- Script execution on the client and on the server
- Lesson 6 (0:50). Accumulation registers
- Lesson 7 (0:25). A simple report
- Lesson 8 (0:40). Templates. Editing templates
- Lesson 9 (0:50). Periodic information registers
- Lesson 10 (0:40). Enumerations
- Lesson 11 (1:20). Posting documents across multiple registers
- Lesson 12 (0:40). Turnover accumulation registers
- Lesson 13 (4:30). Reports
- Theory. Data access methods
- Selecting data from a single table
- Selecting data from two tables
- Breaking down by days in the selected period
- Getting current values from a periodic information register
- Using calculated fields in reports
- Displaying data as a spreadsheet
- Theory. Virtual query tables
- Quiz
- Lesson 14 (3:20). Optimization of posting the Services document
- Lesson 15 (2:50). Charts of characteristic types
- The task at hand
- Understanding charts of characteristic types
- Logical relation between the objects
- Creating new configuration objects
- Modifying configuration objects
- Creating material characteristic types
- Modifying accounting functionality
- Material receipt and expense with property sets specified
- Report with characteristics
- Quiz
- Lesson 16 (1:50). Accounting
- Using charts of characteristic types in accounting
- Adding a chart of characteristic types
- Understanding charts of accounts
- Adding a chart of accounts
- Understanding accounting registers
- Adding an accounting register
- Modifying the GoodsReceipt document
- Modifying the Services document
- Trial balance
- Quiz
- Lesson 17 (1:00). Charts of calculation types and calculation registers
- Lesson 18 (3:40). Using calculation registers
- Lesson 19 (0:40). Database search
- Lesson 20 (0:35). Scheduled jobs
- Lesson 21 (0:40). Editing register records in document forms
- Lesson 22 (1:50). Users and their roles
- Lesson 23 (1:10). Start page and command interface customization
- Lesson 24 (6:10). Data exchange
- Lesson 25 (0:30). Functional options
- Lesson 26 (2:00). Picking list items, avoiding modal windows, and generating data based on other data
- Lesson 27 (2:10). Form development techniques
- Lesson 28 (2:00). Form customization techniques
- Quick developer reference
- 1C:Enterprise script objects used for operations with applied data
- Manipulating object data
- Constants
- Catalogs
- Documents
- Enumerations
- Charts of characteristic types
- Charts of accounts
- Charts of calculation types
- Information registers
- Accumulation registers
- Accounting registers
- Calculation registers
- Exchange plans
- Glossary
- Copyright notice
- Building a mobile application (1C mobile application)
- Introduction
- Do you have everything you need?
- Infobase
- Start programming
- Improving desktop functionality
- Improving interface
- Cross-platform design
- Homework
- Mobile application building example
- Where and how to study 1C:Enterprise
- Business automation
- 1C:Enterprise 8
- 1C partners
- Useful online resources
- About 1C Company
- 1C:Enterprise documentation
- 1C:Enterprise Administrative Service API
- 1C:Enterprise Administrator Guide
- 1C:Enterprise Development Tools
- Chapter 1. What is 1C:Enterprise Development Tools
- Chapter 2. Using 1C:Enterprise Development Tools
- Chapter 3. 1C:Enterprise Development Tools setup
- Chapter 4. Beta version details and limitations
- Chapter 5. Bug reporting guidelines
- Chapter 6. Installation and setup guidelines
- Add-in Development Technology
- Introduction
- Delivery kit directory structure
- Creating add-ins with Native API technology
- Creating add-ins with COM technology
- Creating add-ins with COM technology
- Initializing and unloading add-ins
- 1C:Enterprise script extension
- Localization
- Using COM VARIANT type in data exchange
- COM interfaces of 1C:Enterprise
- Creating windows in 1C:Enterprise environment
- Accessing 1C:Enterprise methods and properties using OLE automation
- Methods and properties available through OLE Automation
- Specifics of add-in development using COM
- Preparing add-ins for working with the web client
- Preparing add-ins for loading them to configurations
- Example descriptions
- 1C:Enterprise Administrator Guide. Client/Server Mode
- 1C:Enterprise Developer Guide
- 1C:Enterprise Software License Acquisition Guide
- 1C:Enterprise User Manual
- Introduction
- Chapter 1. 1C:Enterprise overview
- Chapter 2. Installation and update
- Chapter 3. Getting started
- Chapter 4. User interface
- Chapter 5. Forms
- General form operations
- Fields
- Tumblers
- Progress bars
- Sliders
- Hyperlinks
- Buttons
- Tables
- Groups
- Charts
- Text document fields
- HTML document fields
- Graphical schema fields
- Image fields
- Spreadsheet document fields
- Formatted document fields
- Planner fields
- Drag-and-drop operations
- Saving form values
- Specific features of some forms
- Chapter 6. Lists
- Chapter 7. Data management
- Chapter 8. Reports
- Chapter 9. Report options
- Chapter 10. Service features
- Chapter 11. Customizing applications
- Chapter 12. Getting help
- Chapter 13. Search expressions
- Chapter 14. Web client
- Chapter 15. Slow connection mode
- Chapter 16. Ordinary application mode
- Appendix 1. Data composition system expression language
- Appendix 2. Text editor
- Appendix 3. Spreadsheet document editor
- Understanding spreadsheet documents
- Managing spreadsheet documents
- Creating and opening spreadsheet documents
- Saving spreadsheet documents
- Closing spreadsheet documents
- Viewing spreadsheet documents
- Selecting cells, rows, and columns
- Using search and replacement
- Changing row height and column width in spreadsheet documents
- Moving and copying cells
- Adding and deleting cells
- Splitting cells
- Clearing cells
- Setting custom cell width for each row
- Hiding and showing rows and columns
- Merging cells
- Managing named spreadsheet document areas
- Managing spreadsheet document groups
- Using graphical objects
- Adding graphical objects
- Docking graphical objects
- Selecting and resizing graphical objects
- Aligning graphical object groups
- Setting graphical object group size
- Moving and copying graphical objects
- Changing graphical object order
- Deleting graphical objects
- Grouping graphical objects
- Naming graphical objects
- Managing charts
- Creating charts
- Specifying chart data area
- Managing OLE objects
- Using spreadsheet documents as templates
- Designing templates
- Specifying print settings
- Specifying headers and footers
- Specifying pagination
- Repeating rows and columns on each page
- Specifying print area
- Specifying page settings
- Printing spreadsheet documents
- Editing spreadsheet document and cell properties
- Specifying spreadsheet document cell properties
- Appendix 4. HTML document editor
- Understanding HTML document editor
- Creating HTML documents
- Saving HTML documents
- Editing HTML documents
- Adding text to HTML documents
- Formatting text in HTML documents
- Managing tables in HTML documents
- Adding pictures to HTML documents
- Adding marquees
- Adding hyperlinks
- Adding bookmarks
- Adding horizontal lines
- Formatting HTML documents
- Editing HTML document source code
- Previewing HTML documents
- Appendix 5. Graphical schema editor
- Editing graphical schemas
- Adding graphical schema items
- Using grid
- Managing groups of selected items
- Specifying graphical schema properties
- Graphical schema items
- Specifying general properties
- Specifying appearance properties
- Specifying behavior properties
- Specifying location properties
- Decorative lines
- Specifying appearance properties
- Specifying behavior properties
- Decorations
- Specifying appearance properties
- Activities
- Specifying addressing properties
- Splitting points
- Condition points
- End points
- Start points
- Joins
- Sub-business process points
- Data processor points
- Switches
- Specifying transition properties
- Appendix 6. Geographical schema editor
- 1C:Enterprise User Manual. Taxi Interface
- Introduction
- Chapter 1. Taxi interface
- Chapter 2. Forms
- Chapter 3. Lists
- Chapter 4. Data management
- Chapter 5. Reports
- Chapter 6. Report options
- Chapter 7. Service features
- Chapter 8. Customizing applications
- Chapter 9. Getting help
- Chapter 10. Search expressions
- AutoRun Application
- System requirements
- New functionality and changes
- Version 8.3.16
- New functionality and changes
- New functionality and changes in the 1C:Enterprise mode
- Optimization
- Changes that affect system behavior
- Changes that require modification of configuration and administrative settings
- Renamed objects
- Mobile version of 1C:Enterprise
- Transition from the previous version to the version 8.3.16
- Version 8.3.15
- New functionality and changes
- New functionality and changes in the 1C:Enterprise mode
- Optimization
- Changes that affect system behavior
- Changes that require modification of configuration and administrative settings
- Mobile version of 1C:Enterprise
- Demo configuration changes
- Changes made after the publication of the version
- Transition from the previous version to the version 8.3.15
- Version 8.3.14
- New functionality and changes
- New functionality and changes in the 1C:Enterprise mode
- Optimization
- Changes that affect system behavior
- Changes that require modification of configuration and administrative settings
- Renamed objects
- Mobile version of 1C:Enterprise
- Changes in demo configurations
- Changes performed after version publication
- Transition from the previous version to the version 8.3.14
- Version 8.3.13
- New functionality and changes
- New functionality and changes in the 1C:Enterprise mode
- Optimization
- Changes that affect system behavior
- Changes that require modification of configuration and administrative settings
- Renamed objects
- Mobile version of 1C:Enterprise
- Library updates
- Changes in demo configurations
- Changes performed after version publication
- Transition from the previous version to the version 8.3.13
- Version 8.3.12
- New functionality and changes
- New functionality and changes in the 1C:Enterprise mode
- Optimization
- Changes that affect system behavior
- Changes that require modification of configuration and administrative settings
- Renamed objects
- Mobile version of 1C:Enterprise
- Changes in demo configurations
- Changes performed after version publication
- Transition from the previous version to the version 8.3.12
- Version 8.3.11
- New functionality and changes
- New functionality and changes in the 1C:Enterprise mode
- Optimization
- Changes that affect system behavior
- Changes that require modification of configuration and administrative settings
- Renamed objects
- Mobile platform
- Library updates
- Transition from the previous version to the version 8.3.11
- Version 8.3.10
- New functionality and changes
- New functionality and changes in the 1C:Enterprise mode
- Optimization
- Changes that affect system behavior
- Changes that require modification of configuration and administrative settings
- Renamed objects
- Mobile platform
- Library updates
- Transition from the previous version to the version 8.3.10
- Version 8.3.9
- New functionality and changes
- New functionality and changes in the 1C:Enterprise mode
- Optimization
- Changes that affect system behavior
- Changes that require modification of configuration and administrative settings
- Renamed objects
- Mobile platform
- Library updates
- Transition from the previous version to the version 8.3.9
- Version 8.3.8
- New functionality and changes
- New functionality and changes in the 1C:Enterprise mode
- Optimization
- Changes that affect system behavior
- Changes that require modification of configuration and administrative settings
- Renamed objects
- Mobile platform
- Library updates
- Transition from the previous version to the version 8.3.8
- Version 8.3.7
- New functionality and changes
- New functionality and changes in the 1C:Enterprise mode
- Optimization
- Changes that affect system behavior
- Changes that require modification of configuration and administrative settings
- Renamed objects
- Mobile platform
- Library updates
- Transition from the previous version to the version 8.3.7
- Version 8.3.6
- New functionality and changes
- New functionality and changes in the 1C:Enterprise mode
- Optimization
- Changes that affect system behavior
- Changes that require modification of configuration and administrative settings
- Renamed objects
- Mobile platform
- Library updates
- Transition from the previous version to the version 8.3.6
- Version 8.3.5
- Version 8.3.4
- Version 8.3.3
- New functionality and changes
- New functionality and changes in 1C:Enterprise mode
- Optimization
- Changes that affect system behavior
- Changes that require modification of configuration and administrative settings
- Renamed objects
- Mobile platform
- Transition from the version 8.2 to the version 8.3.3
- Transition from the previous version to version 8.3.3
- Version 8.3.2
- Version 8.3.1
- Version 8.2.19
- Version 8.2.18
- Version 8.2.17
- Version 8.2.16
- Version 8.2.15
- Version 8.2.14
- Version 8.2.13
- Version 8.2.12
- Version 8.2.11
- Version 8.2.10
- Version 8.2.9
- What's New in Version 8.2 Compared to Version 8.1
- Upgrading to Version 8.2 from Versions 8.1 and 8.0
- Infobase That Is Not Connected to Configuration Repository
- Infobase Connected to Configuration Repository
- Configuration Dumped to a File
- Infobase Dumped to a File
- External Data Processor or External Report
- Use of Configurations Developed in the Previous 1C:Enterprise Versions
- Using the Support Files
- Version 8.3.16
- Best practices
- Access rights
- Client/server interaction and security issues
- Code conventions
- Metada Object Naming Conventions
- Module formatting
- Using 1C:Enterprise script clauses
- Catching exceptions in 1C:Enterprise script
- Defining variable value type
- Event log usage specifics
- Expression wrapping rules
- Form module event handlers defined in 1C:Enterprise script
- General requirements to 1C:Enterprise script clauses
- Getting object metadata
- Initializing local variables in advance
- Limitations to usage of the Goto operator
- PredefinedValue function usage specifics
- Preprocessor instructions
- Using compilation directives
- Using duplicate script fragments
- Using global variables in modules
- Creating and changing metadata objects
- Application version control
- Data storages
- Comment attribute of documents
- Deleting obsolete metadata objects from configurations
- Delivering data in configuration packages
- Document posting requirements
- Generic data storage principles
- Handling inactive objects
- Length of configuration object codes and numbers
- Limitations to usage of composite-type attributes
- Name, synonym, and comment
- Reflecting the nature of metadata objects using attributes
- Self-sufficiency of registers
- Tooltips and fill checks
- Using attributes of String type
- Using predefined items
- Using the Active property of register records
- Global configuration requirements
- Business process route map layout recommendations
- Code writing standards for easier localization
- Common module naming rules
- Configuration initialization
- General requirements to configurations
- Metadata object names in configurations
- Restrictions to renaming metadata objects
- Shared configuration development workflow
- Specifics of configuration development for Linux
- Thick client support in managed applications that run in the client/server mode
- Time zone differences
- User settings
- Using common attributes
- Using defined types
- Using functional options
- Using session parameters
- Using subsystems
- Localization guidelines
- User interface development (ordinary application)
- User interface guidelines
- Technical support resources
- Developer resources
- Additional development tools: libraries, data processors, manuals
- Administration
- Backup and restore 1C infobases using SQL Server
- Choosing server-side hardware for 1C:Enterprise system
- Data structure in 1C:Enterprise 8
- How to publish 1C:Enterprise application to Web
- Specifics of 1C:Enteprise server administration on Linux
- Specifics of Oracle DBMS usage
- Tips on infobase backup
- Windows update requirements for 1C:Enterprise 8.3.11
- Development recommendations
- 1C:Enterprise script
- "For each" iterator usage specifics
- 1C:Enterprise script execution process
- Handling script errors
- Infinite recursion
- Messages displayed to users
- Nontransactional data reading
- Passing parameters to procedures and functions by reference and by value
- Recursion in the script
- Specifics of reusing return values
- Storing values in object and form module variables
- User interruption of module execution
- Using temporary files in configurations
- Adapting 1C:Enterprise interfaces for version 8.3.7
- Applied objects
- Autonumbering
- Autonumbering for collaboration
- Developing a periodic information register structure
- Direct deletion of objects without deletion marks and reference integrity check
- Document sequences
- Predefined data: troubleshooting
- Tips on choosing between a subordinate catalog and a tabular section
- Using chart of characteristic types to implement storage of values related to infobase objects
- Using data types for manipulating database objects
- Using script tools for working with applied objects
- Using the DeletionMark field of a database object
- Using the Posted field and the posting process
- Using types for manipulating non-object data
- When to use references, queries, selections, and objects
- Configuration delivery and support
- Configuration delivery and support concept
- Configurations based on several supported vendor configurations
- Creating distribution and update files
- Delivery settings and generation of distribution and update files
- Module merging specifics
- Recommendations for customizing vendor configurations
- Specifics of comparing and merging configurations during the update
- Specifying support options
- Data composition system
- Miscellaneous
- Query language
- Accessing fields from other fields using . (dot)
- Bitness of results of expressions and aggregate functions in query language
- Calculating totals by balance fields
- Catalog field contents
- Complementing query result by days belonging to a specified period
- Details on how to use the group inclusion operator
- Display of reference fields
- Sample queries for hierarchical catalog operations
- Selection of all values belonging to a grouping from a query result
- Sorting in nested queries
- Specifics of connecting to the virtual balances table
- Specifics of DATEDIFF function of the query language
- Specifics of executing SUBSTRING() function of the query language
- Specifics of sorting by reference fields
- Specifics of using "IN HIERARCHY" clause in query language
- Specifics of using the GROUP BY clause
- Specifics of working with the Presentation field and Presentation() function of the query language
- Specifics of working with virtual table of calculation register schedule data
- Using custom expressions in query language totals
- Using filters in queries with virtual tables
- Using FOR UPDATE clause in the query language
- Using the ISNULL() function
- Record- and field-level access restrictions
- Spreadsheet documents
- Values and types
- 1C:Enterprise script
- Mobile platform
- Architecture
- Common recommendations
- Q&A
- Utility features (ordinary application mode)
- TechBlog
- Glossary
