Set Analysis with a count condition

[Anonymous]

I need a set analysis to calculate an expression which should satisfy a count condition and it should look something like this:

=Sum({$<Count(case)={">$(=1)"}>} [POST DATE]- Max (SERV_DATE))

"case" is an autonumbered field created in the script and is a combination of three other fields. But the above set analysis expression that I created is not working. Would appreciate any help or ideas, thanks!

[sunny_talwar]

Against which dimension are you doing this Count(case) check against? POST DATE? SERV_DATE? What is the difference between the two dates here? and why use Max(SERV_DATE)?

[vishsaggi]

You cannot use Aggr function like Count() on left of the "="

May be like:

=Sum({$<case ={"=$(= Count(case) > 1)"}>} [POST DATE]- Max (SERV_DATE))

[sunny_talwar]

case is an autonumbered field.... so Count(case) against case will always = 1

[vishsaggi]

Oops got it. Thanks for that. Can you do a Sum(Aggr(Count(case), case)) ?

[sunny_talwar]

Don't think that will help.... what we need is to know what dimension are we doing this count on...

[vishsaggi]

Got it. Thanks Sunny...