Error garbage after expression ")"

[IE]

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

[Vishal_Gupta]

Can you also show your expression for variable?

[MadhuriReddy]

Hello,

Try this:

=Sum({<Tipo={"Venta"}>} '$(Category)')

[IE]

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]

[marcus_sommer]

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

[IE]

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.

[IE · Accepted solution]

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.

[Vijayqlik4171]

Add any dimension in pivot table and write measure in =Sum({} Category)