Forum Discussion
Gustavo535
Dec 06, 2021Copper Contributor
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!
2 Replies
- Riny_van_EekelenPlatinum Contributor
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.
- DKoontzIron ContributorDo 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!