Suggestion on Grouping

[dadazs]

Hello

I have a formula that looks like:

if (distinctcount({ttcalls.calltype},{ttcalls.empID}) = 2 and (count({ttcalls.calltype},{ttcalls.empID}) = 2 or count({ttcalls.calltype},{ttcalls.empID}) = 4)) and (({ttCalls.calltype}=1 and next({ttCalls.calltype})=2) ) then
"n/a" else
"wrong"


My purpose is to show records where value is wrong. I cannot group on this value because I get an error saying "This formula cannot be used because it must be evaluated later"

Please advise

 

[IanWaterman]

Use the formula in section suppression

In the section suppression formula box

{@yourformula} <> "wrong"

If you need to do any counts or summaries you will need to use similar condition in the Running Total set up box

In this case the evaluation formula will be

{@yourformula} = "wrong"

Ian