Where in expression use Set Analysis?

[#1]

Hello... Need your help!!!

Maybe this is a stupid question, but I´ve tried hard, and cannot make this work...

I´m using this expression to give MTD values:

Sum( $(vSetMTD) MyField)

But I need to exclude something from values, so I´m trying to use Set Analysis, like:

{$<Category-={'FieldName'}>}

Where do I insert this Set analysis???

I´ve tried before variable, after variable... and nothing... It just ignores the set analysis!

Thank you all!

Best Regards,

BS.

[maxgro]

what is?    

$(vSetMTD)

[upendrarajeshir]

Hello BS,

Go through PDF, this may help you.

Thanks & Regards,

Upendra

[#4]

In fact is a Set Analysis in a variable.

I will try now to replicate the variable and make the exclusion inside the variable expression!

[#5]

Not sure what your variable is doing, but the set analysis would go inside the expression.  Something like as follows.

Sum({$<Category-={'FieldName'}>} $(vSetMTD) MyField)

[Joseph_Musekura]

Try

Sum ({<Field1-={‘A’}>}Sales)

will sum all Sales except from field1 :  'A'.

[#7]

Thanks...

Already had it, but thanks anyway!

[#8 · Accepted solution]

Thank you all for trying to help.

Like I´ve said it above, vSetMTD is a variable that allows me Month to Date Analysis! The expression in this variable is in fact a Set Analysis. So what I did was to replicate it, and exclude what I need there, so my expression remains the same.

Sum( $(vSetMTD) MyField)

Thanks!

Problem Solved!