...
3. Compare period and month
Please see Financial Report Column Definition - Comparison Period Formula for comparison Data Formula
| Column No. | Column Header | Column Type | Ledger Entry Type | Amount Type | Formula | Comparison Date Formula | Comparison Period Formula |
|---|---|---|---|---|---|---|---|
| 01 | Current Month | Net Change | Entries | Net Amount | |||
| 02 | Last Month | Net Change | Entries | Net Amount | -1M | ||
| 03 | Prior Year | Net Change | Entries | Net Amount | -1Y | ||
| 04 | Current Year-to-date | Entire Fiscal Year | Entries | Net Amount | |||
| 05 | Last Year-to-Date | Net Change | Entries | Net Amount | -1FY[1..CP] |
...