Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
To achieve what you want, you have to use set analysis also in your variable named VCYM.
if I Write just Max year it doesn't work. without variable it still not work.
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 ?