Aggr in text box

[thomas_skariah]

Hi All,

Can anyone suggest how to display the count of values displayed in pivot box  into a text box.

Attached is the sample Application.

Thanks in advance.

Regards,

Tom

[#2 · Accepted solution]

Hello Tony,

Try the following formula:

=count(distinct aggr(IF((((vAvg)*(20/100))+vAvg)<=SUM(Amt),NRID),NRID))

Regards, Karl

[thomas_skariah]

Thanks Karl

Regards,

Tom