Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all ,
How can I populate in a table for each available day accumulation of the Target with 1500 . So on 01.12 i get 345 000, 02.12 346 500 and so on ?
Thanks !
Hi,
Yes of course, check the code below:
Sales:
Load * Inline [
OrderDate
1/1/2022
31/12/2022
];
Final:
LOAD
Date(MinDate + IterNo()-1) as OrderDate,
IF( RowNo() = 1
, 343500
, Peek( Value ) + 1500
) as Value
While(MinDate + IterNo()-1) <= Num(MaxDate)
;
LOAD
Min(Floor(Date# (OrderDate, 'D/M/YYYY'))) As MinDate,
Max(Floor(Date# (OrderDate, 'D/M/YYYY'))) As MaxDate
Resident Sales ;
Drop table Sales;
Jordy
Climber