Error Message #CALC!

[alcohen43]

I am trying to get a list (spilled) under STOCK where my ledger has in column STATUS = "Open".  I am using the formula

   =SORT(UNIQUE(FILTER(Ledger[Stock],SUMIF(Ledger[Stock],(Ledger[Stock],Ledger[Status]="Open")))))

but all I get returned is #CALC!    What am I doing wrong?

[#2 · Accepted solution]

@alcohen43 

Perhaps you mean

=SORT(UNIQUE(FILTER(Ledger[Stock],Ledger[Status]="Open")))

[#3]

WOW, that worked. Thank you.

[#4]

@alcohen43 , you are welcome