Set Analysis is not working as expected

[alknirmal1]

Hi All,

Actually i am writing a set analysis to filter the entire data based on a particular date.

Expression used : 
=

sum({1<AsOfDate={"=$(=only(date#('2014-09-15','YYYY-MM-DD')))"}>}BookValue_Acct)

Here I am summing up the BookValue_Acct for a particular date 2014-09-15.

This expression doesnt give the correct result..But if I am making the '=' to  '<=' or '>=' , then its working perfectly fine.

Can anybody please advise me on this ?

2) if I have a list box which contains the dates.. If I want to pass the selected value from list box to this set analysis

expression , how can i do that ? i tried giving in different ways .but always it gives the syntax error.

Thanks

Nirmal.

[maxgro]

try to remove bold =

sum({1<AsOfDate={"=$(=only(date#('2014-09-15','YYYY-MM-DD')))"}>}BookValue_Acct)

sum({1<AsOfDate={"$(=only(date#('2014-09-15','YYYY-MM-DD')))"}>}BookValue_Acct)

[alknirmal1]

Thanks a lot for your quick reply.. It works fine !!

Will you be able to help on to pass a list box selected field in the same expression ?

[maxgro]

maybe with concat if you have many values

Re: Data islands and set analysis

the set analysis reference manual

Set Analysis: syntaxes, examples

the set analysis reference post

Re: Re: Components Of Set Analysis