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!

]]>

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 Rob.Iversen@MSXGroup.com. You can also visit our website http://MSXGroup.com for information on our FREE webinars on FRX, Forecaster and Management Reporter.

Thanks

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?)

]]>