# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

## Challenge #28: Formatting Financial Data

12 - Quasar

My solution.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Highlighted
Alteryx Partner

Done.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Highlighted
Alteryx Partner

Done.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Highlighted
Alteryx Certified Partner

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

Highlighted
8 - Asteroid

My solution attached.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Highlighted
Alteryx

Here's my solution

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Highlighted
Alteryx

@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

Highlighted
8 - Asteroid

Solution attached

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Highlighted
Alteryx Partner

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

Highlighted
Alteryx Partner

there's probably a way to make it more efficient but this is what I came with

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.