Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
What if we use {1} with in the identifier?
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
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)
try this...
num(sum({<Standard_Name=>} aggr({<Standard_Name=>}
sum({<Technology-={'No SCR inj','No Fuel BM'},LineSection={'Molder'},Shift_Name-={}>}GoodPieces)
, Standard_Name)))
What shall I do if I want my set expression to be independent of any selections from "Standard_Name"???
Regards,
AS
The above expression would actually actually ignores only standard_Name
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
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
Yes right it was sequence issue , looks like in data set Standard_Name is lowest Hierarchy.
Regards,
AS