Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Good Evening,
How to store the expression values to a date, lets take my today's date is 28/11/2011 --> and expression is Sum(Sales) and Count (Invoice).
Result : 28/11/2011, 500000, 101012
Thanks
Joe
If your expressions are simple, like sum(Sales) or count(Invoice), do it in script:
History:
Load
*
From History.qvd;
Concatenate
Load
Date(Today(),'YYYYMMDD') as Date,
Sum(Sales) as Sales,
Count(Invoice) as Invoices
Resident Fact;
Store History into History.qvd (qvd);
You can also write something like this:
Let v_Date = Today();
History:
Load
Date(Today(),'YYYYMMDD') as Date,
Sum(Sales) as Sales,
Count(Invoice) as Invoices
Resident Fact;
Store History into $(v_Date)History.qvd (qvd);
BR
Miikka