I want to take a value associated with the Max Date in a file, I have tried

[#1]

I have tried Aggr(Sum(Amount), Max(MyDate) , [Int Reference]) but this doesnt seem to work (probably syntax or some such) has anybody got any ideas it also needs to be the correct Line

What I have are a number of records for a month plus a record from the following month which allows me to check if the asset line still existed at the beginning of the month I then need to calculate based on the average value excluding the record value from the following month i.e. avg(Amount) does not work as it takes an extra value. So I was going to sum all then deduct the latest value by date and then divide by a count of the records - 1.

Hope that makes sense.

Thanks in advance for any help.

Alan

[Anonymous]

can you post a sample app...

[#3]

Not sure how to, sorry cant find an upload button anywhere 😞

[Anonymous]

after you click reply, click on the advanced editor option and then you will have an option to "Attach" any file to your post.

[#5]

Here is a sample

[#6]

01-May	500	500
02-May	500	500
03-May	200	200
04-May	700	700
05-May	700	700
06-May	700	700
07-May	700	700
08-May	700	700
09-May	700
Actual average	600	587.5

This might explain it better the average i want to calculate is the 587.5 (exclude the last value or the value with the Latest (max) date)

Thanks in advance

Alan