No of day aggression

[raviityou]

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.

[PradeepReddy]

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;

[jeroen_wagner]

How would you expect the No_of_days to be 1844?