Formula Tool Mastery Question

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.

Help

Accepted answers

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.

All comments

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] + '$' ??

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703