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?
3 Replies
- SergeiBaklanDiamond Contributor
- alcohen43Copper ContributorWOW, that worked. Thank you.
- SergeiBaklanDiamond Contributor
alcohen43 , you are welcome