Set Analysis - Indirect 'p(Field_Value)' AND ignore direct selections 'Field_Value = ' not working

[cmorri1988]

Hi there,

I would like to use indirect selection values, but ignore direct selection values for one field - is this possible?

sum({1< p(Field_Value), Field_Value =>}Other_Sales)

Thanks

[Gysbert_Wassenaar]

That syntax is incorrect. The P function must be used on the right side of the = character of a set modifier. Try this: sum({1< Field_Value = p(Field_Value)>}Other_Sales)

[cmorri1988]

Hi there,

Completely agree, this was a typo, however your solution returns null if a Field_Value is selected within the UI.

It addresses indirect selections, but not ignoring direct selections.

Thanks

[Gysbert_Wassenaar]

I'm sorry. I don't understand what you're trying to do.

This expression will use the Field_Value values that are possible given the user selections and will ignore all other selections the user made:
sum({1< Field_Value = p(Field_Value)>}Other_Sales)

This expression will use all the selections the user made, but ignore the selection in the field Field_Value:
sum({< Field_Value =>}Other_Sales)

Please explain what kind of selections you do want and do not want.