Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Check this may be?
May be
sum({<Indicador={$(=vVolumeTypeText)}>} Valor)
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)
Hi Bruno,
Try the following:
=Sum({<Indicador={$(#vVolumeTypeText)}>} Valor)
Regards,
H
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')
Hi guys,
Thanks a lot for the answers. I tried the three of them and anyone of then works:
I will try send a mock.
could you please try like below:
in your Variable Overview:
vVolumeTypeText
=if($(vVolumeType) = 1, 'Volume hL', 'Volume Pallets')
vVolume_error
Sum({<Indicador={"$(vVolumeTypeText)"}>} Valor)
Check this may be?
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?