How to mix two dimension into a graphic table with formula set analysis

[mahieuphilippe]

Hello everybody,

i find a solution to mix into my expression a formula with inside two dimension.

problem if i select only one of the two dimension,  the result is not correct 

this is my formula : 

=70.51*(273.15/101.325)* Sqrt(((10+101.325))* ((sum ({$<GROUP_NAME={'PHZ/Comb'},ITEM_NAME = {'pression (kPa)'}>}STATEMENT_VALUE))+101.325)

/((15+273.15)*(sum ({$<GROUP_NAME={'PHZ/Comb'},ITEM_NAME = {'Temp (°C)'}>}STATEMENT_VALUE)+273.15)))
*SQRT(mode ({$<GROUP_NAME={"Burner PB*"},ITEM_NAME = {'Primary air'}>}STATEMENT_VALUE)/1000)

the are two dimension   (group name   'Burner PB*'  and  group name ''PHZ/Comb'.

the result is  :

i want to use only one dimension burner PB from 01 to 07 and to have the result of the second dimension 

because the result of my formula is not good  the part concerning the second dimension give '0'

thanks in advance for your help   Ph

[nevopotokcloudinary]

You’re running into a classic set-analysis + selection conflict 🙂

Right now your expression ties both measures to the current selections on GROUP_NAME, so when you only select Burner PB*, the PHZ/Comb part is effectively filtered out and becomes 0.

You need to decouple the second part from the current GROUP_NAME selection, e.g.:

70.51*(273.15/101.325) * sqrt( (10+101.325) * ( sum( {<GROUP_NAME={'PHZ/Comb'}, ITEM_NAME={'pression (kPa)'}, GROUP_NAME-= {'Burner PB*'}>} STATEMENT_VALUE ) + 101.325 ) / ( (15+273.15) * ( sum( {<GROUP_NAME={'PHZ/Comb'}, ITEM_NAME={'Temp (°C)'}, GROUP_NAME-= {'Burner PB*'}>} STATEMENT_VALUE ) + 273.15 ) ) ) * sqrt( Mode( {<GROUP_NAME={'Burner PB*'}, ITEM_NAME={'Primary air'}>} STATEMENT_VALUE ) / 1000 )

Key idea: use set analysis on the PHZ/Comb parts so they always read from that group, even when your selection is only on Burner PB*, while the last part still responds to your Burner PB* selection.