RE:Overall count

[Chanty4u]

Hi all,

What wrng in my expression? in stright table.

Metric: distinc pass&fail for exec testid

and also apply modified date on  condition to view he latest record.

=Count(

if(

Aggr

(

DISTINCT

(

max({<Exec_Status={'Passed','Failed'}>}Exec_ModifiedOn),

lvl_id,Period,Exec_TestID

)

=Exec_ModifiedOn

,Exec_TestID

))

)

[sunny_talwar]

Have you tried setting the Expression total using the third option available within total mode on expression tab of the straight table object's properties?

[Chanty4u]

second exp is gvng  entire values  "0"

[jagan]

Hi,

Try Sum of Rows option in Expression Tab for this expression.

Regards,

jagan.

[sunny_talwar]

What about the first one?

[Chanty4u]

no sunny... nt gvng exact values

[Chanty4u]

no luck

[sunny_talwar]

Have you tried playing with the total mode on Expression tab? Set as Sum of Rows may be?

[sunny_talwar]

I guess, like Jagan has already said, would you be able to share a sample?

[Chanty4u]

dat is also tried..not wrkng......only top of the total is nt shwng correct count...for perticular project only.  remailng all shwng correct

[Chanty4u]

when i select  passed filter only the values of total count is nt gvng correct.....if i select fail it is gvng rows count and total also gvng correct