Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Conditional Formula based on Report Average
- Thread starter beth4530
- Start date
IanWaterman
Programmer
Group Average formula is Average(valuefield, groupfield)
In font format colour formula for Group average
If Average(valuefield, groupfield) <= 0.2xAverage(valuefield) then crRed else crBlack
This will change font to red if Group avg is less than or equal to 20% of total
You can not use Running totals of variables
Ian
In font format colour formula for Group average
If Average(valuefield, groupfield) <= 0.2xAverage(valuefield) then crRed else crBlack
This will change font to red if Group avg is less than or equal to 20% of total
You can not use Running totals of variables
Ian
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question