Hello, I'm trying to figure out what's wrong with this formula on my saved search. When I run the saved search, a bill that is transferring from one account to another should show a positive coming into an account and a negative coming out, but they are both showing up negative due to this formula. Does anyone know what's wrong with it?

Have you tried not multiplying by -1?

@Dora Sterling Try doing another search and run just a formula(currency) with just {amount} and see what you get for values. I've noticed times when the +/- of a value can change depending if it's pulled in a formula like {amount} or you just select the amount field.

@Matt Carter thanks for the help! Can you clarify what you mean by this? Would I use the field option and click "amount" instead of typing it out? When I do that it just puts "{amount}" at the end of my formula

@Dora Sterling Something along these lines, just to verify what the values look like before using the formula you have. You're probably doing the * -1 on a value that doesn't need to be changed.

Got it, thank you!