Account Schedule Column Layout

(0) Share

Report

Posted on by Bogumila

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?

All responses (1)

Answers (0)

Suggested answer

YUN ZHU

75,595 Super User 2024 Season 2 on at

Like (0)

Report

RE: Account Schedule Column Layout

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.