Varibale

[upaliwije]

Hi

I have created a variable as follows

V3month=(PAID_MONTH='May,Jun,Jul')

and use it in a set expression in the following way

SUM({<$(V3month)>}CRE_PAID_AMOUNT)/3

But I do not get the results . Have i made any errors in creating variable or expression. Pls help

[marcus_sommer]

Try:

set V3month = "PAID_MONTH = {'May','Jun','Jul'}";

- Marcus

[upaliwije]

Thanks

Where should I place your script ? when I put it in data variable overview It does not work

[marcus_sommer]

This would be within the load-script - by defining it within the variable-editor you write:

PAID_MONTH = {'May','Jun','Jul'}

- Marcus

[upaliwije]

Tks

However when I put it in Variable over view it is not working

this part gets underlined in red {'May','Jun','Jul'}

What could be reason please

[marcus_sommer · Accepted solution]

The syntax-interpreter tried to interpret it as expression but it's only an expression-part therefore you could ignore the red underlines.

- Marcus

[upaliwije]

Thanks for you expalnation