gl_excel:lineaverageround

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		 Previous revision
Next revisionBoth sides next revision
gl_excel:lineaverageround [2010/06/18 21:41 UTC] – created mwolfegl_excel:lineaverageround [2010/06/21 15:45 UTC] – mwolfe
Line 1: Line 1:
 ====== LineAverageRound ====== ====== LineAverageRound ======
-This function returns the [[LineAverage]] in thousands.  Its usage and parameters are the same as the LineAverage function.  The LineAverage function is called then the following calculations are performed on the result:+This function returns the [[LineAverage]] in thousands.  Its usage and parameters are the same as the LineAverage function, with the exception of the Company parameter*.  The LineAverage function is called then the following calculations are performed on the result:
   * the value returned is rounded to the nearest thousand   * the value returned is rounded to the nearest thousand
   * then divided by one thousand   * then divided by one thousand
-  * then the AvgBal adjustment is applied+  * then the AvgBal User Report Adjustment is applied
  
-%InlineCode{LineAverageRound(UserRpt, LineCode, AvgBalDate, //Company//, //PosNeg//, //StartDate//)}% +%InlineCode{LineAverageRound(UserRpt, LineCode, AvgBalDate, //PosNeg//, //StartDate//)}%  
 + 
 +%fineprint{*NOTE: The Company parameter is not supported for this function because it would require User Report Adjustments to be made on a company by company basis, which would add too much complexity to the process.}%
  
 ==== Example Usage ==== ==== Example Usage ====
Line 22: Line 24:
 {{section>parameters#posneg}} {{section>parameters#posneg}}
 {{section>parameters#startdate}} {{section>parameters#startdate}}
- 
- 
-{{page>lineaverage}} 
  • gl_excel/lineaverageround.txt
  • Last modified: 2023/07/24 14:33 UTC
  • by 127.0.0.1