Set Analysis - Ignore a selection

[Anonymous]

Hi,

Would like to create a set analysis that would ignore a selection, but this won't work. Any idea what the problem is?

If(Fruits = 'Red',

     Sum({$< Fruits = {'Red'}, Apple >}Sweet),

         Sum({$< Fruits = {'Green'}, Apple >}Sweet)

   )

I'd like to ignore the field of Apple.

[Chanty4u]

try

Sum({$< Fruits= {'Red','Green'}, Fruits-={'Apple'} >}Sweet)  

or

If(Fruits = 'Red',

     Sum({$< Fruits= {'Red','Green'}, Fruits-={'Apple'} >}Sweet)  

   )

[chinnuchinni]

hi,

you can exclude the apple like this below:

sum({<fruit_color = {'Red'},fruit_type -= {'Apple'}>}sweet)

[Anil_Babu_Samineni]

You can't define same fields 2 times within Set expression.

Anyway, arwinpabz can you describe exactly what you are doing? You want to exclude the value or field ignore?

[Chanty4u]

yes i missed it it might be other field but he didnt mentioned  so i thought he will change 

Excluding values in Set Analysis

[Anonymous]

This is my real code.. I'd like to ignore the selection of months. But it's not working.

If(vCurrency_1 = 'CND',

Sum({$< Currency = {'CND'}, Month>}Budget),

    Sum({$< Currency = {'USD'}, Month>}Budget)

   )

[sudhirpkuwar]

Try this

If(vCurrency_1 = 'CND',

Sum({$< Currency = {'CND'}, Month=>}Budget),

    Sum({$< Currency = {'USD'}, Month=>}Budget)

   )

[Anonymous]

Already did that but it not working as well..

[tresesco]

Could you share your app with sample data?

[keerthika]

Hi,

     Can you share your app