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],Ledge...
DKoontz
Dec 07, 2021Iron Contributor
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!