How to get average of rows value of straight table into a text object

[agastya]

How to get average of rows value of straight table into a text object

Below expression

(Count({distinct key})-Count({distinct dwg}))/(Count({distinct dwg})-count(Aggr (if(count(distinct key)=1,1),dwg,ppnumbrr)))

@sunny_talwar 

[sunny_talwar]

Something like this

Avg(Aggr(

(Count({distinct key})-Count({distinct dwg}))/(Count({distinct dwg})-count(Aggr (if(count(distinct key)=1,1),dwg,ppnumbrr)))

, Dimension/s))

Replace Dimension/s from the last row with the dimensions you have in your straight table 

[agastya · Accepted solution]

@sunny_talwar used the below expression no use 

In straight table grand total showing "1.80" while used the same expression getting wrong output "1.63"

=Avg(aggr((count({<DWG-={' '}>}distinct DWG)-count({<DWG=-{' '}>}distinct DWG)) /(count({<DWG-={' '}>}DISTINCT DWG)-count(aggr(if(count({<DWG-={' '}>}DISTINCT KEY)=1,1),DWG,NEW_PPN))),NEW_PPN,DWG

[sunny_talwar]

Would you be able to share a sample where we can see this?