Forum Discussion
Error message #CALC!
I´m watching this video on youtube https://www.youtube.com/watch?v=D44EDant0rs&t=254s I´m on the step I place the following formula: =SORT(UNIQUE(FILTER(Ledger[Stock],SUMIF(Ledger[Stock],Ledge...
Gustavo535 I assume you have the Table with the correct column names in place, otherwise you would have seen a pop-up window stating "There's a problem with this formula ......"
I copied your formula into a new sheet with a table called Ledger and two columns for Stock and Units. And it works as expected. The #CALC! error occurs when either of the columns referenced has no data. Try for yourself in the attached file.