#1 2019-02-27 17:23:22

FLU73
Member
Registered: 2018-10-25
Posts: 38

Strange results with computation in filters (analytical.top)

Hello,

I've a simple case where the selected table fields in a dynamic list are :Customer, Year, value

I want to display a report with the top 5 of of customers.

I use a filter on the value column where the formula is : ${analytical.top(5)}

when excecuting the preview I get a result with 9 records !?
Values of agregation are correct, these 9 customers have the correct turnover calculated from all their invoices lines in the table.

As my table contains the lines of invoices, I apply an agregration on the value column.

NB : if I don't apply agregation, and select the Invoice Nr and line Nr, I get the top 5 of Invoice lines.

Offline

#2 2019-02-28 12:14:58

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,250
Website

Re: Strange results with computation in filters (analytical.top)

Hi FLU73,

can you please post your exact version (rsversion.properties) and some screenshots that show the problem? You can use https://imgbb.com/ for posting these here.

Regards,
Eduardo

Offline

#3 2019-02-28 13:04:25

FLU73
Member
Registered: 2018-10-25
Posts: 38

Re: Strange results with computation in filters (analytical.top)

Hi Eduardo,

RS version: 3.0.5-6005

here below is the screenshot of the filter definition to get Top(5)

Report-Server-Topn.png

and the result (9 records)

Report-Server-Topn-results.png

Offline

#4 2019-02-28 13:19:27

FLU73
Member
Registered: 2018-10-25
Posts: 38

Re: Strange results with computation in filters (analytical.top)

Here is an overview of the underlying records of the source datawarehouse table, we can see when executing the query:
vbeln = invoice Nr
posnr = Invoice line Nr

Report-Server-query-preview.png

Offline

#5 2019-03-06 08:06:29

eduardo
Administrator
Registered: 2016-11-01
Posts: 1,250
Website

Re: Strange results with computation in filters (analytical.top)

Hi FLU73,

I created ticket RS-3352 for this and I will update here when we have more information.

Regards,
Eduardo

Offline

Board footer

Powered by FluxBB