Forum

Notifications
Clear all

Error when using a dynamic array in the stocks portfolio

2 Posts
2 Users
0 Reactions
63 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: 968
Prominent 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: