Challenge #28: Formatting Financial Data

[T_Willins]

My solution.

Spoiler

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

[PhilBalderson]

Done.

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

[PhilBalderson]

Done.

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

[shawnbres]

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

[hbraunius]

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.

[TonyA]

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.

[TonyA]

@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

[nnilz]

Solution attached

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

[Alekh]

Spoiler

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

[jdemeaux]

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.