Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I want to aggregate no of day like selected date – Net due date customer wise. I tried but not figuring what’s wrong in that please help. Please find attached sample data and expected result.
try some thing like this...
Temp:
LOAD Customer,
Doc,
Line,
Date,
Net_Due_DateD,
Date-Net_Due_DateD as Days1,
Day,
Amount,
Product
FROM [no of days. xls.xls]
(biff, embedded labels, table is Data$);
Final:
Load Customer,
sum(Days1) as "No.of Days",
Sum(Amount) as Amount,
Sum(Product) as Product
Resident Test
group by Customer;
Drop table Temp;
How would you expect the No_of_days to be 1844?