EOM report showing wrong at Access point

[nareshthavidishetty]

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..

[qliksus]

Was there any difference in the selection between the Selection made during PDF creation and in the  access point

[marcus_sommer]

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