Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a problem with a expression that works perfectly in a chart but not in a pivot or straight table.
=Sum({<Tipo={"Venta"}>} $(Category))
The variable Category is selected in an Imput Box and the list of fields is:
[FSC Recycled Credit];[FSC Mix Credit];[FSC Controlled Wood];[No Certificado]
The error gives me is Error garbage after expression ")"
Could somebody help me?
Thanks in advance
Sorry. it is solved.
I was eliminating the dimensions one by one untill the problem desappeared.
The problem is the field Categoria as dimension.
I changed it as variable in the dimension and all works.
Can you also show your expression for variable?
Hello,
Try this:
=Sum({<Tipo={"Venta"}>} '$(Category)')
The problem follows with Sum({<Tipo={"Venta"}>} '$(Category)').
I attach the way to create the variable that select some fields in the script.
In the list is [FSC Recycled Credit];[FSC Mix Credit];[FSC Controlled Wood];[No Certificado]
Your approach will work within the table, too. But it looked that you misspelled the variable. In your expression you name it Category and within the input-box the name is Categoria.
- Marcus
I traslated the name for understanding.
With Categoria is the same.
It is not the problem.
It is very rare, because in a bar chart the expression works, but in the pivot and straigh table, not.
Sorry. it is solved.
I was eliminating the dimensions one by one untill the problem desappeared.
The problem is the field Categoria as dimension.
I changed it as variable in the dimension and all works.