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.
Solved! Go to 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.
Bravo and thank you on the Length format!
How do I 'add' the '$' with a '+'?
[Formatted Total] + '$' ??
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.