Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
=SUM({$<YTD = {"=Len(Trim(Replace(YTD,'-','')))=0"}>}Amount)
Thanks for the response, Unfortunately I am still getting a " 0 ".
Any thoughts?
It's not working because of Null value in YTD. Try this
=sum({1-<YTD={'YTD'}>} Amount)
Provide your data.... Both My and Anbu's solution should work...
Or
=sum({<Amount=E({<YTD={'YTD'}>})>} Amount)
set analysis
sum({1-<YTD={"*"}>} Amount)
no sa
sum(if(IsNull(YTD),Amount))