SOLVED

Error Message #CALC!

New Contributor

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
best response confirmed by allyreckerman (Microsoft)
Solution

@alcohen43 

Perhaps you mean

=SORT(UNIQUE(FILTER(Ledger[Stock],Ledger[Status]="Open")))
WOW, that worked. Thank you.

@alcohen43 , you are welcome