Formula Tool Mastery Question

[Airedelapaz]

Spoiler

Input:

Output:

I hate to have to ask such a beginner question, but I'm a beginner.  I'm working the ADAPT program and have a question on a conditional string expression within the Formula tool.  This is what I'm doing....wrong....  Can someone please help?  Also, the exercise mentions concatenate to add "$" to string.  Snippets in the Spoiler.

Thank you in advance for your help and if there's a smarter way to do this I'm all ears. 

[markcurry · Accepted solution]

I think the issue is with your Length function, instead of IF Length([Formatted Total] = 😎 .... it should be IF Length([Formatted Total]) = 8.....

You could also just add a "$" with a + to your [Formatted Total] field.

[Airedelapaz]

Bravo and thank you on the Length format!

How do I 'add' the '$' with a '+'?  

[Formatted Total] + '$'  ??

[markcurry]

Yes that's it, but you probably want to put it at front of the string...

 "$" + [Formatted Tool]

As you're are adding an extra character to the string, make sure you have a space for the extra character, so if the [Formatted Tool] is a string data type with size of 10 and you have a number 123,456.78, when you add the $ it will truncate the value to $123,456.7 unless you increase the size with a select tool first.  You mightn't need do, just check for any truncated warnings in the Results window.