Hi Friends ,
I have a variable called " diff" created by using the calculation max
(status code)-min(status code).
diff= max(status code)-min(statuscode)
I need to apply a filter as if this variable diff is greater than 0 . But i couldn’t see this variable “diff” in format->filter
in add button .
i need to filter the report having other values based on this value . Can anyone tell me the solution in clear ? Thanks
psk (BOB member since 2004-08-04)
Unfortunately, you can’t filter on an aggregate. Look here for a clear explanation of why, and for a hint for how to to a workaround.
Anita Craig 
(BOB member since 2002-06-17)
Hello all,
I was informed that the ability to filter on variables (aggregates?) is supported in BO 6.5. Ex: Var=Number of Men in Class with Grade of A+Number of Women in Class with Grade of A, report filter on classes where Var > 15. Does anyone have verification of this?
Thanks!
Mike Marr
Business Analyst
mnkmarr (BOB member since 2003-10-22)