Performance issue using if

[risabhroy_03]

Hey I am using the below expression to calculate the sum of Quantity for the maximum Invoice Date for each company code

Sum(aggr(if(Invoice_Date_GMT=date(max(total<Company_Code>Invoice_Date_GMT)),sum(Quantity)),Company_Code))

This is giving me correct results but takes lots of time.

Can anyone please suggest me a way without if?