Hi all...want to run this by you with hope for an easy solution I'm overlooking.
This is the output of a summary report. All is perfect, except for when it 'averages the average columns' (shown in red on cells I7 and I15)
Like the columns prior that make up this total, this total column amount should simply divide column H by column C instead of averaging.
How can I simply have this total reflect an amount equal to dividing total line (H7 by C7)?
Hi
You can unlock the report, remove the total and add another data item with something like this:
total([Current Amount Excluding Bonus] ) / total([Current Hours]) for [Department]
By the way, are you posting your actual data here? Your managers may not be too happy to see this
Quote from: cognostechie on 11 Apr 2024 05:30:14 PMHi
You can unlock the report, remove the total and add another data item with something like this:
total([Current Amount Excluding Bonus] ) / total([Current Hours]) for [Department]
By the way, are you posting your actual data here? Your managers may not be too happy to see this
Thanks...and never, it's a sandbox environment : )