web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Financial Reports - Fo...
Small and medium business | Business Central, N...
Suggested answer

Financial Reports - Formulas ending with percent sign require Set Base

(1) ShareShare
ReportReport
Posted on by Marcella Affonso 192
Our Finance team continues to encounter the error below. When we create a copy of the report, such as "TRIAL BAL" or "INC STATEMENT," everything works fine. However, this issue occurs for only one user, and she insists she is not modifying the formula. Please see the error and the setup details below
 
 
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 92,161 Super User 2025 Season 2 on at
    Financial Reports - Formulas ending with percent sign require Set Base
    If it is very difficult to find the problem, it is recommended that you recreate the report.
    Or just ask the developer to debug and see which line the error occurs.
     
    Thanks.
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 29,345 Super User 2025 Season 2 on at
    Financial Reports - Formulas ending with percent sign require Set Base
    Is that the same for the column definition? or only in the row definition as per the screenshot? I would check the column definition as well.
  • Marcella Affonso Profile Picture
    Marcella Affonso 192 on at
    Financial Reports - Formulas ending with percent sign require Set Base
    We do not have any formulas that use percent %
     
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 92,161 Super User 2025 Season 2 on at
    Financial Reports - Formulas ending with percent sign require Set Base
    Hi, Please check the settings below.
     
    Thanks
    ZHU
  • Suggested answer
    Valentin Castravet Profile Picture
    Valentin Castravet 29,345 Super User 2025 Season 2 on at
    Financial Reports - Formulas ending with percent sign require Set Base
    Does the report row definition have a row designated as 'Set Base for Percent?' Typically you get that error if you don't. You can follow these instructions to set it up:
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 3,885

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 3,405

#3
Sumit Singh Profile Picture

Sumit Singh 2,837

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans