Excel Add-In for Zoho Books

Build 22.0.8479

BusinessPerformanceRatiosReport

Generated schema file.

Table Specific Information

Select

The 本製品 will use the Zoho Books API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the 本製品.

  • TransactionDate supports the '=' comparison.
  • ToMonth supports the '=' comparison.
  • FromMonth supports the '=' comparison.
For example:
    SELECT * FROM businessperformanceratiosreport

    SELECT * FROM businessperformanceratiosreport WHERE TransactionDate = 'PreviousQuarter'

    SELECT * FROM businessperformanceratiosreport WHERE TransactionDate = 'CustomDate' and FromMonth = '2022-10' and ToMonth = '2022-11'

Columns

Name Type References SupportedOperators Description
DashboardMonth String DashboardMonth
Denominator Integer Denominator
DiffLastQuarter Double DiffLastQuarter
DiffLastSixMonths Double DiffLastSixMonths
DiffLastTwelveMonths Double DiffLastTwelveMonths
DiffLastYear Double DiffLastYear
LastQuarter Integer LastQuarter
LastSixMonths Double LastSixMonths
LastTwelveMonths Double LastTwelveMonths
LastYear Double LastYear
Numerator Integer Numerator
PreLastQuarter Double PreLastQuarter
PreLastSixMonths Double PreLastSixMonths
PreLastTwelveMonths Double PreLastTwelveMonths
PreLastYear Double PreLastYear
PreviousValues String PreviousValues
Ratio Integer Ratio
RatioPrev Integer RatioPrev

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
TransactionDate String Filter transaction by any transaction date.

使用できる値は次のとおりです。PreviousQuarter, PreviousYear, LastSixMonths, LastTwelveMonths, CustomDate

ToMonth String To Months
FromMonth String From Month
UseState Boolean UseState

デフォルト値はtrueです。

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479