Forum Discussion
alcohen43
Jun 19, 2021Copper Contributor
Error Message #CALC!
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?