Set analysis (using -= with a YTD indicator)

[zagzebski]

My Data:

YTD	Amount
YTD	75
-	25

I want to return the null value of YTD which is 25, but I keep getting a " 0 ":

=sum({<YTD-={'YTD'}>} Amount)

[MK_QSL]

=SUM({$<YTD = {"=Len(Trim(Replace(YTD,'-','')))=0"}>}Amount)

[zagzebski]

Thanks for the response, Unfortunately I am still getting a " 0 ".

Any thoughts?

[anbu1984]

It's not working because of Null value in YTD. Try this

=sum({1-<YTD={'YTD'}>} Amount)

[MK_QSL]

Provide your data.... Both My and Anbu's solution should work...

[anbu1984]

Or

=sum({<Amount=E({<YTD={'YTD'}>})>} Amount)

[maxgro]

set analysis

sum({1-<YTD={"*"}>} Amount)

no sa

sum(if(IsNull(YTD),Amount))