Factorise a Set Analysis member

[#1]

Hi Guys,

I'm building a set analysis like.

=Sum ({<Field1 ={'A'}, Field2={'B'}>+<Field1 ={'A'}, Field3={'C'}>}Value)

So far it works, I just need to write it in another way.... and I cannot find the proper syntax.

I'd like something like Field1 ={'A'} and ( Field2={'B'} or Field3={'C'})

Why?

Because I will be able to put them invariables...

(In my data field1 is a time condition, field2 and 3 fields in a business hierarchy),

Any Idea?

Merry Xmas.

Eva

[tresB · Accepted solution]

Field1 ={'A'} and ( Field2={'B'} or Field3={'C'})

=>

              <Field1 ={'A'}>* (<Field2={'B'}> + <Field3={'C'}>)

[jyothish8807]

Hi Eva,

Try this:

=sum({ <Field1 ={'A'}>* (<Field2={'B'}> + <Field3={'C'}>)}Value)

Regards

KC