Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a expression that I use on certain graphs, but I want to convert it to a variable variable with parameters. This is the original expression (working):
= Sum({<PeriodoNumVol = {">=$(=min(PeriodoNum))<=$(=max(PeriodoNum))"},[Tipo Registro]=,[OrigenVol]={'Vol.Real'},TipoVol={'Generado'},PeriodoNum=,Periodo=>}VolumenReal)/1000
This is how I've defined my variable:
= Sum({<PeriodoNumVol = {">=$(=min(PeriodoNum))<=$(=max(PeriodoNum))"},[Tipo Registro]=,[OrigenVol]={$1},TipoVol={'Generado'},PeriodoNum=,Periodo=>}VolumenReal)/1000
And how I use it in the expression of graphs.:
=$(Volumen('Vol.Real'))
Any idea why it is not working?
Thanks!!!
Solved
I was using the equal (=) in var and in expression,
1) Place the =$(Volumen('Vol.Real')) expression in a straight table.
2) Leave the Label value blnk for this expression.
3) Hover over the column heading to see the expanded expression. Does it look correct? If not, correct it. If it looks correct, right click - copy cell to clipboad and paste the expanded expression in a Text Ojbect to debug.
-Rob