Ignore Certain Selections

[mariamovasheli]

Hello,

I This is my set analysis:

sum({< VariablesName = {'Neogas Revenue Price  USD'},Division = {'Gas Retail'} ,$(VCYM)>}Amount)

/

Sum({<VariablesName ={'Ebitda'},Division = {'Gas Retail'},AccountTypeName={'Revenue'},$(VCYM)>}Quantity)

But When I select other Division it shows nothing. I want This not to change with division and column_counterparts but then I put it in this set analysis it doesn't work and it still changes. Can You please tel me how to Ignore selection of this columns?

[agigliotti]

To achieve what you want, you have to use set analysis also in your variable named VCYM.

[mariamovasheli]

if I Write just Max year it doesn't work. without variable it still not work.

[agigliotti]

are you saying that the below expression:

Sum( {< VariablesName = {'Neogas Revenue Price  USD'},Division = {'Gas Retail'} >} Amount )

/

Sum( {< VariablesName = {'Ebitda'}, Division = {'Gas Retail'}, AccountTypeName = {'Revenue'} >}Quantity)

changes if you select a value of field Division ?