Skip to main content

Hi All,

I'm having an issue figuring out how to best format a formula for my situation. 
This is probably very simple but I need a hand. 

Here are my fields:
"Total" - Currency field with numeric value
"Total Copy" - Formula Field 
"Is Income?" - Single Select field

Basically, I need Total Copy to take & convert Total's value to a negative or positive number based on Is Income.

I have this so far to grab from Total and make it a negative: IF({Is Income?} = BLANK(), {Total} *-1, "") 
But now I need it to also recognize if Is Income is not empty so it can copy from Total and deliver a positive value instead of staying blank in that case.
 
Any help is appreciated 😊

Hi @Huhviss ,

This is what you mean?

IF(
{Is Income?},
{Total},
{Total}*-1
)

 

Hi @Huhviss ,

This is what you mean?

IF(
{Is Income?},
{Total},
{Total}*-1
)

 


Exactly what I mean! Thanks so much. I think I was just overcomplicating it in my head 🙂

Reply


Terms & Conditions