Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
i have a request from a customers who whats to spead income according to fixed rules
for each customer i get invoice number , date , sales amount and numbers of months to speard
each invoice can get different no of months .
those sales as service contracts , so in finance report , the CFO need to spread the income
for the life of the contracts .
enclosed is a file where the yellow colour is the data i get
and green is the data i need to create
the file is a sample , the real file is very big
thanks
gidon
Use below script
================================
Temp:
Load *, Months as TotalMonths Inline
[
Customer, Date, Invoice, Sales, Months
200, 01/02/2014, I100, 5000, 5
210, 01/04/2014, I150, 7200, 6
];
NoConcatenate
Data:
Load
Customer,
Date(AddMonths(Date,(IterNo()-1))) as Date,
Invoice & '-' & (IterNo()) as Invoice,
Sales/TotalMonths as Sales,
Months
Resident Temp
While IterNo() <= Months;
Drop Table Temp;
Use below script
================================
Temp:
Load *, Months as TotalMonths Inline
[
Customer, Date, Invoice, Sales, Months
200, 01/02/2014, I100, 5000, 5
210, 01/04/2014, I150, 7200, 6
];
NoConcatenate
Data:
Load
Customer,
Date(AddMonths(Date,(IterNo()-1))) as Date,
Invoice & '-' & (IterNo()) as Invoice,
Sales/TotalMonths as Sales,
Months
Resident Temp
While IterNo() <= Months;
Drop Table Temp;
hello
thanks for your help
gidon