Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
gl_excel:parameters [2014/03/13 12:10 UTC] – add LineNum and RptName to list of parameters mwolfe | gl_excel:parameters [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 3: | Line 3: | ||
===== To Quote or not to Quote ===== | ===== To Quote or not to Quote ===== | ||
- | * Use quotes if you are using the **actual** data in the formula: | + | * Use quotes if you are using the **actual** data in the formula: |
- | * Don’t use quotes if you are **referring** to the cell that holds the data: %InlineCode{=Balance(A1, | + | * Don’t use quotes if you are **referring** to the cell that holds the data: **=Balance(A1, |
- | * Cell A1 would then contain | + | * Cell A1 would then contain |
- | * Cell B1 would then contain | + | * Cell B1 would then contain |
Please note that all examples given on this page show quoted data, as would be used if the values were directly entered into the formula. | Please note that all examples given on this page show quoted data, as would be used if the values were directly entered into the formula. | ||
Line 26: | Line 26: | ||
" | " | ||
" | " | ||
- | %fineprint{Used in: [[AvgBal]], [[LineAverage]], | + | %fineprint{Used in: [[AvgBal]], [[FedRptAvgBal]], [[LineAverage]], |
==== BalanceDate ==== | ==== BalanceDate ==== | ||
Line 33: | Line 33: | ||
" | " | ||
" | " | ||
- | %fineprint{Used in: [[Balance]], | + | %fineprint{Used in: [[Balance]], [[FedRptBalance]], [[LineBalance]], |
==== BudgetDate ==== | ==== BudgetDate ==== | ||
The date that represents the **month and year** used to retrieve the budget numbers | The date that represents the **month and year** used to retrieve the budget numbers | ||
Line 39: | Line 39: | ||
" | " | ||
" | " | ||
- | %fineprint{Used in: [[Budget]], [[LineBudget]], | + | %fineprint{Used in: [[Budget]], [[FedRptBudget]], [[LineBudget]], |
==== ColDate ==== | ==== ColDate ==== | ||
The date of the user report column created by going to Edit Columns from the Edit User Report form in the General Ledger. | The date of the user report column created by going to Edit Columns from the Edit User Report form in the General Ledger. | ||
Line 62: | Line 62: | ||
" | " | ||
| | ||
- | %fineprint{Used in: [[LineAverage]], | + | %fineprint{Used in: [[FedRptAvgBal]], |
+ | |||
+ | ==== Concept ==== | ||
+ | The 8-character alphanumeric Call Report concept code. | ||
+ | " | ||
+ | " | ||
+ | %fineprint{Used in: [[CallRptDescription]], | ||
==== LineCode ==== | ==== LineCode ==== | ||
Line 86: | Line 92: | ||
" | " | ||
- | %fineprint{Used in: [[AvgBal]], [[Balance]], | + | %fineprint{Used in: [[AvgBal]], [[Balance]], [[FedRptAvgBal]], |
+ | |||
+ | ==== RptDate ==== | ||
+ | The month-end date that corresponds to the respective Call Report reporting period. | ||
+ | " | ||
+ | " | ||
+ | %fineprint{Used in: [[CallRptValue]]}% | ||
==== RptName ==== | ==== RptName ==== | ||
Line 99: | Line 111: | ||
" | " | ||
" | " | ||
- | %fineprint{Used in: [[AvgBal]], [[LineAverageRound]]}% | + | %fineprint{Used in: [[AvgBal]], [[FedRptAvgBal]], [[LineAverageRound]]}% |
==== UserRpt ==== | ==== UserRpt ==== |