Make ammount positive or negative based on the concept kind.

[LukeSphinx]

Hi there. I'm not a native English speaker but I'll try my best to explain what I want to do.

I'm doing a ledger app.
When I add a new movement I have to select a Concept, for example, "Dinner" or "Taxi".
Concepts have their own table and each one of them has a "kind" which is Income or Outcome.

Then I have to fill the amount field which I'd like to turn negative or positive based on the Concept kind before selected.

Do you know how can I achieve that?

[Steve]

You currently have a column in which the user enters the amount as a positive number. Add another column and give it an App formula expression that computes the desired positive or negative value from the user-entered value.