web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Financial Reporting

Small and medium business | Business Central, N...

Suggested Answer

Financial Reporting

(0) Share

Report

Report

Posted on by MANJUNATH DHANAPAL

175

Hi Team,

In the comparison period formula section, I am trying to use some operations but getting an error message. Wondering how I could do this. The formula I am using is FY[1..12]-FY[1..CP] - however, I am getting the below error - screenshot attached,

Please help.

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Dallefeld 225 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

You can add a column that is set to not show for FY[1..12] Then change column 4 to a Formula

Was this reply helpful? Yes No
MANJUNATH DHANAPAL 175 on at

Like (0)

Report
Copy link

Link copied!

Hi Kim,

I am not able to understand. Can you please be more specific? Which column should I add?

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,857 Super User 2026 Season 1

#2

YUN ZHU 1,047 Super User 2026 Season 1

#3

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans