Forum

Notifications
Clear all

Error when using a dynamic array in the stocks portfolio

2 Posts
2 Users
0 Reactions
458 Views
(@vanessabradb)
Posts: 1
New Member
Topic starter
 

Hi All, 

My formula does work and i'm unsure why 

=SORT(UNIQUE(FILTER(Account[Stock],SUMIF(Account{Stock],Account[Stock],Account[Units])<>0)))


 
Posted : 15/12/2021 11:24 am
Anders Sehlstedt
(@sehlsan)
Posts: 986
Noble Member
 

Hello,

Your subject line mentions there is an error, but you write that it works. I did have a reference error when viewing the uploaded file, but that can be an error on my side. Anyway, which part of the formula gives an error or raises questions?

Br,
Anders


 
Posted : 15/12/2021 6:18 pm
Share:
0