Forum

Notifications
Clear all

Stock Dashboard not sorting or filtering correctly

2 Posts
2 Users
0 Reactions
142 Views
(@bkearns16)
Posts: 1
New Member
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
(@mynda)
Posts: 4762
Member Admin
 

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
Share: