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?

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

YUN ZHU

100,212 Super User 2026 Season 1 on at

Like (0)

Report

Copy link

Link copied!

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.