Error in set modifier ad hoc element list: ',' or ')' expected in formula

[#1]

Hi all,

I am trying to do the following formula

vVolumeType = 0 or 1 depending on one button

vVolumeTypeText = if($(vVolumeType), 'Volume hL', 'Volume Pallets')

Both of these two formulas work perfectly, but when I put it in a Set Analysis shows the title error.

sum({<Indicador={$(vVolumeTypeText)}>} Valor)

Although the following configuration works:

sum({<Indicador={'Volume hL'}>} Valor) or this configuration sum({<Indicador={'Volume Pallets'}>} Valor)

and I do not know what to do.

If anyone could help me I would be appreciated.

Regards,

[ahaahaaha]

May be

sum({<Indicador={$(=vVolumeTypeText)}>} Valor)

[Gysbert_Wassenaar]

Try putting an = character in front of the expression in the variable: =if($(vVolumeType), 'Volume hL', 'Volume Pallets')

And put the dollar expansion in single quotes: sum({<Indicador={'$(vVolumeTypeText)'}>} Valor)

[hector_munoz]

Hi Bruno,

Try the following:

=Sum({<Indicador={$(#vVolumeTypeText)}>} Valor)

Regards,

H

[zebhashmi]

is it a typo that you do not have complete logic check

vVolumeTypeText = if($(vVolumeType), 'Volume hL', 'Volume Pallets')

it should be

vVolumeTypeText = if($(vVolumeType) = 1, 'Volume hL', 'Volume Pallets')

[#6]

Hi guys,

Thanks a lot for the answers. I tried the three of them and anyone of then works:

• sum({<Indicador={$(=vVolumeTypeText)}>} Valor) is still have the same error
• =if($(vVolumeType), 'Volume hL', 'Volume Pallets')this formula works only without the = sign (if I put it this formula does not work anymore)
• =Sum({<Indicador={$(#vVolumeTypeText)}>} Valor)does not work too even with the = sign.
• I tried this too vVolumeTypeText = if($(vVolumeType) = 1, 'Volume hL', 'Volume Pallets'), but is having the same error.

I will try send a mock.

[#7]

Hi guys,

I put a link for an mock here:

mockt.qvw

Regards,

[sudeepkm]

could you please try like below:

in your Variable Overview:

vVolumeTypeText

=if($(vVolumeType) = 1, 'Volume hL', 'Volume Pallets')

vVolume_error

Sum({<Indicador={"$(vVolumeTypeText)"}>} Valor)

[vishsaggi · Accepted solution]

Check this may be?

[#10]

Many thanks,

Works perfectly.

Even though I do not understood why. I saw that in some cases we use = in variable and $ and another, could you, please, tell me why this difference?