gl_excel:lineaverageround

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
Next revisionBoth sides next revision
gl_excel:lineaverageround [2010/06/18 21:42 UTC] – 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}}
- 
- 
  • gl_excel/lineaverageround.txt
  • Last modified: 2023/07/24 14:33 UTC
  • by 127.0.0.1