make the value of field negative or positive

AppSheet AppSheet Q&A
1

hey guys

How do I make the value of field “B” negative
If field “A” = true
or positive
If field “A” = false

2

Hi @alfakeah

You can use the Valid_If expression on the column B settings (black pen):

OR(
  AND([_THIS]<0,[A]),
  AND([_THIS]>=0,NOT([A]))
)

Aurelien_0-1653327523413.png
Aurelien_0-1653327523413.png763×490 23.1 KB

2 Likes
3

IF([A], ABS([B]) * -1, ABS([B]))

1 Like
4

Aurelien
I thank you
But the expression did not work

Do I put the expression in field “B”?

5

Thank you Joseph

What do you mean by “ABS” ?

6

ABS() command returns the absolute value القيمة المطلقة of a number/decimal. It is part of AppSheet’s Math Expressions.

1 Like
7

Lovely
This expression was modified by me

IF([A]=“Debit”, ABS([B]) * -1, ABS([B]))

put it in Valid_If expression

But it doesn’t work and it gives me this message:
The expression is valid but its result type ‘Number’ is not one of the expected types: Yes/No, List

What’s the solution?

8

As I understood from the post, you want to make the value positive or negative.

If instead you wanted to check the validity of the value using Valid if, then you should use this expression:

IF([A] = “Debit”, [_This] < 0, [_This] > 0)

3 Likes
9

I really need the first expression that makes the value positive or negative
But I put it in the box.
App formula
But the field disappears because the expression deals with a value already entered in field “B”.
And I want the user to enter the value in field “B”.

10

Columns having an app formula can neither be edited through user input nor through actions. The solution is to have this formula in another column, and use this new column in calculations and in the app views.

2 Likes