BKPER_BALANCES_TOTAL
Fetch the total balances values from Accounts and Groups:
=BKPER_BALANCES_TOTAL(bookId, cache, query, expanded, transposed, hideNames)
Sample usage
=BKPER_BALANCES_TOTAL("agtzfmJrcGVyLWhyZHITCxIGTGVkZ2VyGICAgKD_4bMLDA", 1, “group:'Revenue' after:01/2016 before:01/2017”, TRUE, FALSE, FALSE)
Explaining the syntax:
bookId: string - The universal Book Id.
cache: number - Cache-control. Increase to clean cache and force fetch update.
query: string - The query.
expanded: TRUE, FALSE or number - Expand group tree. True to expand itself, -1 to expand all subgroups. -2 to expand all accounts. Any number to expand up to a specific level
transposed: TRUE or FALSE - Transpose the result
hideNames:TRUE or FALSE - Hide account/group names
Note:
- The result is ordered from the largest to the smallest amount.