Set Analysis include values

[amit_saini]

Hi Folks,

Below is my scenario:

In Text box for Output '11611' I'm calling below expression:

=num(sum({$<Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

Now what I'm looking for is that Output should remain always 11611 even if any users are selecting or filtering the data based on "Standard_Name" (Should includes all values)

I'm trying below expression , but it not working:

=num(sum({$<Standard_Name=,Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

Or

=num(sum({$<Standard_Name=p(Standard_Name),Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

Please suggest what should be right logic.

Regards,

AS

[Anil_Babu_Samineni]

What if we use {1} with in the identifier?

[amit_saini]

Anil I can do something like below:

Sum({1} [Sales]) : sum of everything (All dimensions are completely reset to All)

But my issue is selections should applicable on other fields like Technology , LineSection ...etc , but not only on Standard_Name

Regards,

Amit

[Anil_Babu_Samineni]

True, When we cover P() it will filter for all possible values

=num(sum({1<Standard_Name=p(Standard_Name),Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

[Anonymous]

try this...

num(sum({<Standard_Name=>}  aggr({<Standard_Name=>}

sum({<Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)

, Standard_Name)))

[amit_saini]

What shall I do if I want my set expression to be independent of any selections from "Standard_Name"???

Regards,

AS

[Anonymous]

The above expression would actually actually ignores only standard_Name

[amit_saini · Accepted solution]

I tried below as it's working :

(num(sum({$<Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={},Standard_Name=>}GoodPieces))

Regards,

AS

[Anil_Babu_Samineni]

Does that mean, The sequential order working for you? Seems you just placed ignore field to the last place. Is that is the cause? I wonder

[amit_saini]

Yes right it was sequence issue , looks like in data set Standard_Name is lowest Hierarchy.

Regards,

AS