Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have Fund field and Assets Field .When i select Date field i want the fund field max date and sum(Assets).
eg :
suppose i select fund 3 i want the max date of 30/11/19 sum(Assets)
i attached my sample data
please help any one as soon as possible
thank you
Ok , thank You
i am waiting for the positive answer
positive answer?
I am waiting for the positive reply.
last two days i am working on this requirement i asked many people no one can solve this problem
Now for me your the only hope for me to solve my problem
I want to help, but I need to understand what you are doing? Can you provide the output for the above set of data that I provided?
@princyal I fear we've missed your deadline for getting this worked out. Despite best efforts we haven't had enough information on the challenge you are facing to be able to help by the looks of it. As per Sunny's reply, if you still want to resolve this we just need some more detail on exactly what your data looks like and what you trying to achieve.
Hi,
Again I attached my sample data. This is my actual data format So much data only even I received, the client requirement is
If I selected 30/09/19 I would just sum the first 3 records for Fund1,fund2, Fund3 (8000+10000+7000)
So, if I select Reportdate=30/11/209, I would get the sum of assets marked in yellow colors are
if I select Reportdate=30/12/209 on that Fund4, Fund5, Fund 6 is repeated again (10000+15000+20000-5000+5000+10000)
hi ,
This Is My Actual Data so much data only we received from client
try this one
AAA:
LOAD [Check No],
Report_Date,
Fund,
Assets
FROM
[111.txt]
(txt, codepage is 28591, embedded labels, delimiter is '\t', msq);
Temp:
load
[Check No],
Report_Date,
Fund,
Assets,
numsum( Assets, Peek( 'Bsum' ) ) as Bsum
resident AAA order by
Report_Date,
Fund;
drop table AAA;
output: