Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I m loading sales table monthly with the following autogenerate variables
LET vToday = NUM(Today());
LET vBaseMonth = NUM(Month(AddMonths(Today(1)-1,0)));
LET vBaseYear = Year(AddMonths(Today(1)-1,0));
LET vFileMonthName = $(vBaseYear)&'_'& NUM($(vBaseMonth),'00');
then i m storing the monthly file into qvds.
i have sales qvds from Jan 2015 to Apr 2016.
for my report, i m extracting all the sales qvds from Jan 2015 to Apr 2016 and storing into single qvd named 'TotalSales.qvd' in my folder path and i m using this TotalSales (qvd) for my report.
when i get data from this TotalSales qvd for a particular month, i m getting wrong sales value.
but if i get data from the monthly qvd, i m getting correct sales value.
i cant figure the exact reason.
Please help me
Hi,
It seems to be a data issue. What you will have to find is whether you are doing any extra calculation or any logic which is there while creating the TotalSales QVD.
Regards,
Kaushik Solanki
No.
i have monthly qvds like
Sales_2015_01
.
.
..
Sales_2015_12
Sales_2016_01
.
.
Sales_2016_04
While loading TotalSales qvd, i do the following
Load *
from
QVD\Sales_*.qvd
(qvd);