Sum only latest value

[Anonymous]

Hi!

Polices may have multiple transactions, I would want to sum amounts for only the latest transactions assuming the date keeps updating each time but the amount field keeps several layers. So for instance when i click on a policy it displays only the latest date but several occurences of the amount which when summed gives undesirable result.

Kwame

Thanks

[sushil353]

could you have any sample application or data..

or else try to use the firstsortedvalue function.

HTH

Sushil

[Anonymous]

I could only attach this and all I wanted is to sum only the most recent value in the m_Sum Assured.

Kwame