27
Hi
I am creating Account Schedule report and I have doubt how to use formulas in column Comparison Period Formula in Column Type setup. I have a report where I don't know what should I put in Actual PY Period 4, and Actual YTD 2022. Anybody helps me with formulas of these dates?
Hi, hope the following can give you some hints.
| 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. |
| -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. |
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,246
Super User 2024 Season 2
#2
Martin Dráb
228,041
Super User 2024 Season 2
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (
