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[...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 19, 2021

    alcohen43 

    Perhaps you mean

    =SORT(UNIQUE(FILTER(Ledger[Stock],Ledger[Status]="Open")))
alcohen43's avatar
alcohen43
Copper Contributor
Jun 19, 2021
WOW, that worked. Thank you.

Resources