Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Actually we have deliver 2 kinds of reports one is PDF and another is AccessPoint.
The EOM data in PDF report is showing correct but in Accesspoint it showing wrong data.
EX:
PDF : Electronis sales for 30th April,2016 = 20.6%
Access Point: Electronis sales for 30th April,2016 = 19.5%
Which is not correct and these should match each other.
Logic Used:
If(/*District_RetailScorecard='District' or*/ [Location] = '888',
(sum({$<Year = {$(vRunYear)},Month = {$(vRunMonth)},[Current Sales Class Nbr] = {001}>} TOTAL ([Invoice Merchandise Amt] + [Invoice Price Concession Amt]))
-
sum({$<Year = {$(=max(Year)-1)},Month = {"<=$(=max({<Year={$(=max(Year))}>}Month))>$(=max({<Year={$(=max(Year))}>} Month)-1)"},
[Reported Date] = {"<=$(=addyears(max([Reported Date]),-1))"},[Current Sales Class Nbr] = {001}>} TOTAL ([Invoice Merchandise Amt] + [Invoice Price Concession Amt])))
/
(sum({$<Year = {$(=max(Year)-1)},Month = {"<=$(=max({<Year={$(=max(Year))}>}Month))>$(=max({<Year={$(=max(Year))}>} Month)-1)"},
[Reported Date] = {"<=$(=addyears(max([Reported Date]),-1))"}, [Current Sales Class Nbr] = {001}>} TOTAL ([Invoice Merchandise Amt] + [Invoice Price Concession Amt]))),
//Default - totals for individual Districts or Stores
(sum({$<Year = {$(vRunYear)},Month = {$(vRunMonth)},[Current Sales Class Nbr] = {001}>} [Invoice Merchandise Amt] + [Invoice Price Concession Amt])
-
sum({$<Year = {$(=max(Year)-1)},Month = {"<=$(=max({<Year={$(=max(Year))}>}Month))>$(=max({<Year={$(=max(Year))}>} Month)-1)"},
[Reported Date] = {"<=$(=addyears(max([Reported Date]),-1))"},[Current Sales Class Nbr] = {001}>} [Invoice Merchandise Amt] + [Invoice Price Concession Amt]))
/
(sum({$<Year = {$(=max(Year)-1)},Month = {"<=$(=max({<Year={$(=max(Year))}>}Month))>$(=max({<Year={$(=max(Year))}>} Month)-1)"},
[Reported Date] = {"<=$(=addyears(max([Reported Date]),-1))"}, [Current Sales Class Nbr] = {001}>} [Invoice Merchandise Amt] + [Invoice Price Concession Amt])))
Thanks..
Was there any difference in the selection between the Selection made during PDF creation and in the access point
Bothe reports are based on the same datamodel with the same version of data? If yes, then could the reason only a different selection and/or any implemented section access respectively other user-related - on osuser() - conditions.
- Marcus