Print Page | Close Window

FRx Calculation Off on the Total column

Printed From: Microsoft Dynamics Forums
Category: Microsoft Management Reporter and Microsoft FRx
Forum Name: FRx
Forum Discription: Installation, Upgrade, and Report Design
URL: http://www.MicrosoftDynamicsForums.com/forums/forum_posts.asp?TID=4244
Printed Date: October 23 2019 at 6:14am


Topic: FRx Calculation Off on the Total column
Posted By: GPwall
Subject: FRx Calculation Off on the Total column
Date Posted: February 01 2010 at 8:16pm
We have several P&L reports that shows a 12 month trend with totals for every month as a row and a Total YTD column.  At the bottom of the report we have Frx to calculate the total percentage of cost and the % is correct. 
 
The last column after the 12 month trend is the Total YTD column and the percentage of cost divided by revenue is always wrong.  When we export the report with formulas it is showing that the calculation is adding all the monthly percentage instead of dividing the total YTD cost by Total YTD revenue. How do we fix the formulas since Frx only allows us to use 1 calculation (add or divide and not both?)



Replies:
Posted By: rivers1
Date Posted: June 06 2010 at 8:00am
You should be able to fix this pretty quickly as long as there are no complex calculation in the column layout.  What you are experiencing is what we call Calculation Priority Conflict.  In the cell of the report where you have the problem, there are two conflicting calculations going on.  The one in the row should take one value divided by another to get your percentage.  The calc in the column is adding across the other columns.  Only one of those two calculations will present its data in the report.  By default FRx does the Row calcs first, so the Column calc is what you see displaying. 
 
To change this:
1. Go into the Catalog for this report
2. Click the Report Options => Advanced tab
3. In the upper right you will see the Calculation Priority setting.  Change it from Rows first to Columns first.
4. Save the catalog and generate.
 
I think this will solve your issue but if not, or if you have further problems or questions, please feel free to contact me at mailto:Rob.Iversen@MSXGroup.com - Rob.Iversen@MSXGroup.com .  You can also visit our website http://MSXGroup.com - http://MSXGroup.com for information on our FREE webinars on FRX, Forecaster and Management Reporter.
 
Thanks
 


-------------
Rob Iversen


Posted By: ThomasLinney
Date Posted: March 08 2017 at 12:40am
Greetings to all, my dearest folks! Thanks for the detailed and exclusive overview. If you're in need of an  extremely perfect essay, you're welcome to use  http://bigessaywriter.com/blog/essay-on-conflict-make-love-not-war" rel="nofollow - http://bigessaywriter.com/blog/essay-on-conflict-make-love-not-war !



Print Page | Close Window