Skip to Content
0

using contextual operator

Apr 13 at 07:33 AM

22

avatar image

Hello

(sorry for my english)

i've a problem with using an contextual operator (where) in webi report.

In the report, there several data source, all fusionned on the product code.

in one of data sources, i have the list of command for a product. A product can have 0, 1 or more commands on different dates.

I want to show the value of the command which is the first in date.

For exemple,

Product / command number / Date / quantity

Product 1 / Command 1 / 01/05/2018 / 100

Product 1 / Command 2 / 01/06/2018 / 200

in the report, i want to show only 100, and not 300 in quantity for the product 1.

I've tried :

quantity where (min(date) = date) but i always have 300.

How to do this so ?

thanks

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Apr 13 at 09:23 AM
0

create one variable Show/Hide=if(date=min(date) in (product) then "Show" else "Hide"

Apply filter on Show/Hide variable where equal to Show to display one record.

Share
10 |10000 characters needed characters left characters exceeded