Is it possible to get a percentage to appear on a TOT row?
For Row 890, I need to take the total and divide it by the total in Row 265 but the column is blank when I generate the report
Row Definition:
Column Definition:
Hi,
Thanks for including the screen shots of your report. The CBR row isn't something that will actually print. It's a reference point for the B/BASEROW calculation in the column. The CBR row is the BASEROW. For example, on row 890, the calculation in Column C will take the amount from Column B, row 890 and divide by the amount in Column B row 265, since row 265 is the BASEROW at that point. You've restricted row 890 to only print in Columns B, D, F, and G. So not value will print in Column C for row 890. If you remove the column restrictions or add C to the column restrictions, you'll see the calculation.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156