Variable within set analysis

[ivandrago]

Hi,

I have the attached document and want to know if this is possible?

I have created a variable called vSuccess within there I have a list of ID's that i declare as being a success (1,2). I am then trying to use this variable within the expression as per the text object 'Success based on variable (NOT WORKING)' and expecting to see the same result as the text box where the result shows

'Success 1450'

Thanks

[#2]

Use

='Success based on variable (NOT WORKING) '&chr(10)&chr(10)&sum({$<ID={$(vSuccess)}>}OrderVal)

The variable vSuccess needs to be encapsulated by parentheses or be used with dollar sign expansion $().

[Anonymous]

Ivan

It's just a minor syntax error, this works:

='Success based on variable (NOT WORKING) '&chr(10)&chr(10)&sum({$<ID={$(vSuccess)}>}OrderVal)

Regards,

Michael