May I kindly ask for you help?
I am using the following formula to retrieve equity assets of a single perm ID(5000030092):
=TR($B$4,"TR.TotalEquityAssets","Curn=USD SDate=2021-12-31 CH=Fd",$C$3)
The formula specifies the date, but the resulting output is a column of numbers, not a unique number..
Could you please tell me why and how I should modify the formula to retrive only one number for a given date?
Thanks in advance for your help!