Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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 ?
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