Need to calculate avg

[bharatkishore]

Hi All

I and dimension called A have written an expression for calculating a metric called unique contact. The expression is

=(sum([Total Sends])-sum([Total Unsubscribes]))-sum([Total Bouncebacks])

By writing this i have got a value for example say 1799.

By doing avg of that whole 10 values i got 6003.

Now  i need to calculate the avg which is like 1799/6003.=29.97

Can you please tell me how  can i achive this. 

Attached excel for more understanding

[sunny_talwar]

May he this:

=(Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks])

/

Avg(TOTAL Aggr((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]), Name))

[bharatkishore]

Hi Sunny,

Thanks for your reply.

Please find the attached screen shot. I m not getting the exact output.

[sunny_talwar]

Can you share the screenshot of expression you have used for the avg column?

[florentina_doga]

try a expresion like

sum(value)

/

average(sum(total value))

[bharatkishore]

Please find the attached screen shot..

[sunny_talwar]

Try this:

=((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))

/

Avg(TOTAL Aggr((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]), Name))

[bharatkishore]

Hi Sunny,

Please find the attached.. I am not getting the correct values. Don't know where i am missing

[sunny_talwar]

Are you using calculated dimension by any chance?

[bharatkishore]

No No.. i m not using.. directly taken the field.