Hi Silutions ,
I'm not sure if this trick will help you on your server, but you can try.
Write a formula with All() function and divide it by the unique count of the field you use in All() function.
Get something like this:
( RSUM( [Total DriverBasePay] ),all([Fiscal Period ID]) )/
( RSUM( [# of unique FiscalYearMonth] ),all([Fiscal Period ID]) )/
[# of unique Fiscal Period ID]
Always here to help,
Angelina from QBeeQ
[email protected]
Angelina,
Unfortunately what you suggest doesn't work. It gives incorrect results whether all periods or just one period is shown. I'll study a little more on your approach to see if I can modify to work. Thanks for taking a look and tell Michael I said hey!
Jim
