Forum Discussion

Gustavo535's avatar
Gustavo535
Copper Contributor
Dec 06, 2021

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],Ledger[Stock],Ledger[Units])<>0)))

 

And it shows me #CALC!

excel

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Dec 07, 2021

    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.

  • DKoontz's avatar
    DKoontz
    Iron Contributor
    Dec 07, 2021
    Do you have a separate worksheet and table named "Ledger"? the formula relies on this table being formatted with the same headers, the names in brackets [ ], represent headers so if there is any difference in your table name or table headers it would throw an error. Double check this and let me know if that fixes it!

Resources