The formula below to be use if you want to create the report with period comparison.
Please note, the formula must enter in the Comparison Date Formula field.
| Abbreviation | Description |
|---|---|
| P | Period. |
| LP | Last period of a fiscal year, half-year, or quarter. |
| CP | Current period of a fiscal year, half-year, or quarter. Use CP in formulas to set the period that starts or ends the formula. For example, FY[1..CP] denotes the time from the beginning of the current fiscal year to the current period. |
| FY | Fiscal year. For example, FY[1..3] denotes the first quarter of the current fiscal year. |
Examples of formulas:
| Formula | Description |
|---|---|
| <Blank> | Current period. |
| -1Y | Compare to same period one year earlier. |
| -1P | Previous period. |
| -1FY[1..LP] | Entire previous fiscal year. |
| -1FY | Current period in previous fiscal year. |
| -1FY[1..3] | First quarter of previous fiscal year. |
| -1FY[1..CP] | From the beginning of the previous fiscal year to the current period in the previous fiscal year, including both periods. |
| -1FY[CP..LP] | From the current period in previous fiscal year to the last period of the previous fiscal year, including both periods. |