Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE
SOLVED

Error Message #CALC!

Copper 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

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@alcohen43 

Perhaps you mean

=SORT(UNIQUE(FILTER(Ledger[Stock],Ledger[Status]="Open")))

View solution in original post