Average TAT for unique Doc no

[#1]

Hi

Please assist.

I am looking for an expression that will help me calculate the average TAT for only the unique Doc No.

Please view sample data

Thanks

[Anonymous]

Simply try:

Doc No as a Dim

Expression:  avg(TAT)

[Anonymous]

may be this as well?

=aggr(avg(TAT), DocNo)  as Expression

[brunobertels]

Hi

hope it helps :

[#5]

Hi

I need a solution to the below data that will show one Average in a Text box.

It must only do a calculation for the unique Doc No.

[reddy-s]

HI Charles,

Try this:

Sum(aggr(avg(TaT),Docno))

[Anonymous]

Did you try what I suggested you??