Re: How to compute Stock Amount using RangeSum(Above( and get amount =-1,505,155.9 ?
Sorry it's still not clear to me. So you want to get LY amount by using your expression. But that expression doesn't return value correctly, is that right? Can you explain what that expression means. Is that accumulate stock?
Also, you mentioned if remove TOTAL then Previous month amount is 0? can you send me screenshot?