community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #28: Formatting Financial Data

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.

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.

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.

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

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.

Alteryx
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.

Alteryx
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

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.

Alteryx Partner

 

 


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

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.