How to calculate the Last sold value

[Former Member]

Hi All,

Can we get the material last sold price based on the materials, suppose 20/11/2007 my material has been sold with value of $100, on 15/11/2007 same material sold with value of $80, so in my report coloum i wolud like to see the value as $80,

Best regards,

Rams.

[Former Member · Accepted solution]

Rams,

1.you can create KF use last value

2.query designer property set the KF as last value.

Sam

[Former Member · Accepted solution]

Hi Sam,

I have already tried, but the result is showing wrong, could u pls provide any other solution.

Best Regards,

Rams.

[Former Member · Accepted solution]

Rams,

Did you try creat new keyfigue, use aggregation TAB--exception aggregatelast value?

Ag.refrence.char use 0calday

[Former Member]

Try with exception aggregate on the date.