Qlik sense

[Chithra]

I should get the sum of SCHdays based on each project ID.If I give like this I am getting average of schdays:

Num(Avg(Aggr(Avg({<Practiceold={'IDS','TS'}>}SCHDays),E2ETATHOLDPROJECTID)),'#,##0' ), how to modify this expression to get sum of schdays  in Qlik sense table.

[PrashantSangle]

Try by writing Sum in outer aggregation,

Like 

Num(Sum(Aggr(Avg({<Practiceold={'IDS','TS'}>}SCHDays),E2ETATHOLDPROJECTID)),'#,##0' )

Regards,

Prashant Sangle

[Chithra]

Thank you so much Prashant for your update.

If I give Sum in outer aggregation , it will work when I consider individual IDs however when I want to see Quartely or monthly ,it is not giving the correct value.

[PrashantSangle]

Can you explain in details?

Like what is your current expression, Dimesion

Also if possible can you share the sample data with expected output.

Regards,

Prashant Sangle