Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
142
Views
Topic starter
The following formula is not working correctly in cell B6(it pulls in every reference of the stocks in the Ledger table):
=SORT(UNIQUE(FILTER(Ledger[Stock],SUMIF(Ledger[Stock],Ledger[Stock],Ledger[Units])<>0)))
Sheet is attached.
Please advise
Posted : 08/06/2021 8:39 am
Hi Brad,
Welcome to our forum!
When I opened the file I could see momentarily the duplicate stocks, but as soon as the formula recalculated, I only see a unique list. I wonder if your Calculation is set to manual? Check on the Formulas tab > Calculation Options.
Mynda
Posted : 08/06/2021 7:53 pm