set expression issue

[Anonymous]

Hi,

I need a set expression in this formula:

count({AS <Field1=, Field2=, ..., FieldN=>} distinct Media)

As you see in my set expression I list all available fields in my application except the field Media.

Is it possible to simplify the formula? Maybe, there is way not to list all the field available.

Thank you in advance,

Larisa

[lironbaram]

count({1<Media=p(Media)>}Distinct Media)

[avinashelite]

try like :

Count({1}distinct Media)

this will give the count independent of all the other fields

[jagan]

Hi,

Check this link

Ignore all selections except some specific fields using Set Analysis

OR else try

count({1<Media=P(Media)>} distinct Media)

Regards,

Jagan.

[maxgro]

I think here

Ignore all selections except some specific fields using Set Analysis

[Anonymous]

Thanks everyone for your comments!

Almost each of you advised the expression {1<Media=P(Media)>} or {AS*1<Media=P(Media)>} as I'm using an alternate state.

I don't know why but it gives a different result than my initial formula: count({AS <Field1=, Field2=, ..., FieldN=>} distinct Media). Maybe, it is due to the peculiariteis of my application.

I'll use 'count({AS <Field1=, Field2=, ..., FieldN=>} distinct Media)' in my app then because I don't see a simpler alternative.

Thanks for sharing the link with some extra explanation!