How to calculate Sales AVG per customer

[Sefib]

Hi Everyone ,
I'm new to qlik sense and I need to create KPI dashboard for an interview exam.
I'm trying to calculate sales AVG per customer.
I tried the following expression, but it didn't work as expected:
Avg(Aggr(Sum(AMOUNT), CustomerID))
Expected Result: 4,838
Actual Result: 4,785
Attached Sales.qvd file
I would appreciate your help 🙂

[rafael_neves]

Hello, how are you?
the formula seems to be right, can not find the attachment, can you send again?

graciously
Rafael Yoshida

[Sefib]

Hi Rafael,

Thanks for your quick replay :-).

I experienced some technical issue uploading the file.

Can I send it to you by email?

Thanks,

Sefi

[rafael_neves]

clear

yoshida@yoshidaqlik.com.br

[rafael_neves]

Hi

Is there a filter you need to do?
in the file sent the AVG number does not match the one entered

graciously

Rafael Yoshida