on 11-22-2007 1:30 PM
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.
Rams,
1.you can create KF use last value
2.query designer property set the KF as last value.
Sam
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Try with exception aggregate on the date.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.