Forum Discussion

alcohen43's avatar
alcohen43
Copper Contributor
Jun 19, 2021

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?

 

Share

Resources