Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Management Reporter: &...

Management Reporter: "calculation must be on data row" referring to an underscore

(0) Share

Report

Posted on by Community Member Microsoft Employee

Client just migrated from FRx to MR. They are on build 2.0.1700.66. There are two company databases. Company A runs the reports fine, however, the row formats had the typical missing accounts after migration.

The Company B gets an error message on every row that has an underscore and is above a TOT row:

Message: Analysis Error: Report Row Calculation [R189] - Calculation must be on data row.

It does not error out on underscore rows beneath a TOT row.

Further, when Company B is selected in a Report Definition, the accounts do not display on the row format. They display in the same row format in the same Report Definition for Company A.

Is anyone experiencing this?

Thanks, Elsa.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

Re: Management Reporter: "calculation must be on data row" referring to an underscore

Account segments need to be called the same thing accross companies. Slapping forehead...

blogs.msdn.com/.../how-dimension-names-impact-management-reporter.aspx