Jump to content
The ibi Community has moved to a new platform: Please Sign In and choose Forgot Password to continue

Hello, I am building a report that uses row totals to calcul...

Casey Green

Recommended Posts

Hello, I am building a report that uses row totals to calculate an average value for the row. Usually when calculating percent or averages in a COLUMN total, Ill select the Recalculate totals option (so that it doesnt simply add the percent values together). This doesnt seem to be an option when adding row totals. Does anyone know of a way to have the row totals recalculate in the same way that column totals can recalculate Thank you!
Link to comment
Share on other sites

Sorry, I should have specified Im using WebFocus Designer. I have the ON TABLE RECOMPUTE in my text file and is correctly recalculating column totals. When I include the ACROSS fieldname RECOMPUTE, and run the table it returns an error. Does the ACROSS line apply just to the field SEATS in your example Would I need to include this line after every row I want recalculated
Link to comment
Share on other sites

To have RECOMPUTE working, you need a COMPUTE which you dont

The only COMPUTE that you have is just the display of an existing field in the source table.

So basically its not a COMPUTEd field since you do not perform any calculation for AVE_SPEND.

As per my sample I do perform calculation. And RECOMPUTE just tell FOCUS to re-apply the calculation at the total instead of performing a column/row total

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...