This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackMy solution.
This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.
Can someone explain the formula below?
if isnull([Fund]) then [TNA Latest
month-end ($mil)] else [Row-1:ShareClass] endif
Particularly the "month-end ($mil)" portion.
Thank you
@shawnbres Notice that "TNA Latestmonth-end ($mil)" appears between square brackets. That means the entire string is actually the name of the field. If you look at it in a browse tool you won't see the entire field name because it's too long to fit in the column width. If the field was named "X" instead of "TNA Latestmonth-end ($mil)" then the formula would be:
if isnull([Fund]) then [X] else [Row-1:ShareClass] endif
This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.