Set Analysis - Get List of current selections into specific field

[#1]

Hi Guys,

The following expression works, but How do I change the values in the list, to the list of selected values in a specific field?

=Sum( {$ < [SalesTargets.STMonth] = {'01', '02', '05'} > } SalesTargets.Quant)

=Sum( {$ < [SalesTargets.STMonth] = { IvMontNo } > } SalesTargets.Quant) I have tried this but it is not working.

Thanks in advance,

Aldo.

[Miguel_Angel_Baeyens]

Hello Aldo,

You can use the following

=Sum( {$ < [SalesTargets.STMonth] = P(IvMontNo) > } SalesTargets.Quant)

Hope that helps.

[#3]

Hi there,

The following seems to be working:

=Sum( {<[SalesTargets.STMonth] = {$(=GetFieldSelections(IvMonthNo, ',',12))} >} SalesTargets.Quant)

I tried: =Sum( {$ < [SalesTargets.STMonth] = P(IvMonthNo) > } SalesTargets.Quant) but it is not working. What's the meaning of P ?

Thanks,

Aldo.

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

P() is used in set analysis to get all possible values in one field while E() is used to get all excluded values for the specified field.

On the other hand, GetCurrentSelections will work, although if you use it for non-numeric fields you will need to quote values

chr(39) & GetFieldSelections(Field, chr(39) & ',' & chr(39), 12) & chr(39)

So the final result look like

'A', 'B', 'C'

Regards.

[#5]

Thanks man.