Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use an equal sign first in your variable definition
Dafinis,
Following example
Try either
Status = {'$(vStatus)'}
or
Status = {'$(=vStatus)'}
Hey see the attached file.
sum({<Status={$(vStatus)} >} Amount)
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!
Use an equal sign first in your variable definition
Thanks!
See attached