String variable in Set Analysis

[dafnis14]

Hi All,

I can't figure out why the following  Set Analysis example doesn't work:

Temp:
LOAD * INLINE [
Code, Status, Amount
9,A,100
3,B,200
6,A, 500
1,A,100
2,B,200
4,A, 500
];

I have defined a variable vStatus that can be either A or B:

IF(DAY(Today()) >15,'A', 'B')

The following expression doesn't work. The result is 0.

(I have tried all kinds of variations Of writing the variable).

sum({<Status = {'$vStatus'} >} Amount)

Your kind help is highly appreciated.

Thanks!

Message was edited by: Dafnis X Attached is my file. Thanks

[rogerioqv]

Dafinis,

Following example

[swuehl]

Try either

Status = {'$(vStatus)'}

or

Status = {'$(=vStatus)'}

[#4]

Hey see the attached file.

[maxgro]

sum({<Status={$(vStatus)} >} Amount)

[dafnis14]

Hi,

You can see that the various options aren't working..

I can't open the files sent by you kind people until tomorrow ...

Thanks!

[swuehl · Accepted solution]

Use an equal sign first in your variable definition

[dafnis14]

Thanks!

[Anonymous]

See attached