Can't help - for the same reason that QV can't calculate this - but can expalin.
You have aggregation function Max() within another aggregation function Sum(). It doesn't have meaning. In chart expressions, you can do something like this using aggr() function:
sum(aggr(max(amount), <some fields by wghich you aggregate max>))
In script, you use "group by" to tell by what fields to aggregate. In your case, you calculate sum() by %LeaseKey. It has nothing to do with max(). From the description, I can't guess what that max() means - max by what? Probably (just guessing), you need to find out your max-es first, create them as new fields, and use these newe fields in your sum(). I cannot guess by what the max-es should be aggregated in your case.
This helped a little bit but I am still getting an issue.
When I create the table in the script and then add the table into table box it shows the data correctly. when I add the same fields in a table chart and do sum([Annual Amount]) it returns a random nr which is away higher than what it should be.
I am assuing that i should get the same nr when using Sum([Annual Amount]) as [Annual Amount] because the lease key is uniqe on this table.
Please let me know your thoughts and thank you so much for your help.
