Help with IF percentage formula for negative values

[CottageKeeper]

Hello AT Community

I’ve got a formula partially working but I’m having some difficulty tweaking it to just the right look.

Looking for numbers in the SAL field that result as a negative to show the emoji - so far so good. How do I make positive numbers in the ‘test’ field show as a percentage with only two numbers behind the decimal and with proper rounding up?

Thanks in advance for your brilliance!

[nea_lpatil]

@CottageKeeper

I have created field called “Lisa” and it uses single formula instead of using multiple formulas.It will help you to use formula without need of understanding dependent formulas.
Name of field I am using is called “decimal”. You need to replace “decimal” with your fieldname in your base.

Neal

[CottageKeeper]

Thanks again Neal, I still can’t get it to work right, I’m using the SAL field in the formula where you used the decimal field.

[nea_lpatil]

@CottageKeeper

Formula expects field to be Decimal instead of currency.

At present your SAL is of type currency. Change its formatting to be Decimal.
i.e. Customize field SAL formatting to be
Decimal(1.0) with precision 1.00

Neal

[CottageKeeper]

Thanks, Neal, unfortunately, that is not an option. I have to keep the SAL field as a dollar amount.

This is what I was able to do as a workaround. I can’t have the emoticon face populate for negative numbers in the SAL field - which what I was looking for. But until there is a better solution, I’ll have to stick with this:

I am grateful for your support in all of this!

[nea_lpatil]

@CottageKeeper

Try the following

• Create field SALCOPY of type formula. Formula will be SAL% and format it as decimal with precision 1.00
• Create field SalEmoji and its formula will be the formula with emoji but use fieldname SALCOPY in that formula
• SALEmoji field will have data as per your need.
• SALCOPY can be hidden afterwards.

Neal