Pick and Match

[markgraham123]

Hi,

I have a requirement which is as follows:

I have Warehouse, ID, Units

Where Warehouse comes from Table1 and ID and Units were from Table2.

When i select Warehouse from Table1, Count(Distinct(ID) from Table 2and Sum(Units) from Table2 should be displaye d in table.

=Pick(Match([W1], 'ABC'), Sum(TOTAL{<W2= {'ABC'}>} [Units]))

=Pick(Match([W1], 'ABC'), Count(Distinct{<W2= {'ABC'}>} ID))

The above coed is not giving me right answer...

Can anyone look into this.

[swuehl]

What do you expect to see?

I do see a correct value returned (1)

W1	=Pick(Match([W1], 'a')+1, Null(),Count(Distinct{<W2= {'a'}>} LBCD))	sum(Qty)
		4601
a	1	234
b		4323
c		32
d		12

[markgraham123]

Hi,

i.e. in the above report it is showing Count(Distinct(LBCD)) is 1.

I wanna see the LBCD.."4545" in the report.

[swuehl]

A count() will just count the field values, not showing them. Use only() or concat() instead.

And since you are using a set analysis filter like {<W2 = {'a'}>}, the returned LBCD will be 22, not 4545.

It's quite unclear what you are trying to achieve.

Maybe it's better for us to help you if you start explaining your requirements.

[markgraham123]

Hi,

For cross checking purposes whether the Set analysis count i'm using working correct or not...

I wanna display the LBCD...

For eg:

he above report it is showing Count(Distinct(LBCD)) is 1.

I wanna see the LBCD..its fetching is "4545" for my own reference (not in the original report).

[markgraham123]

Hi Sir,

Pls lemme know is there any option to look the fetching value.