Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

The right code for an additional field....

Former Member
0 Likes
920

Hi all

Creating a query, I've written the follow code for the additional field "FATTURATO"

CLEAR FATTURATO.

FATTURATO = LFC1-UM01U + LFC1-UM02U +

LFC1-UM03U + LFC1-UM04U +

LFC1-UM05U + LFC1-UM06U +

LFC1-UM07U + LFC1-UM08U +

LFC1-UM09U + LFC1-UM10U +

LFC1-UM11U + LFC1-UM12U.

But the query lists a negative value for the additional field "FATTURATO"

What modication in the code should I put to change the value in positive?

Thanks

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
870

FATTURATO = LFC1-UM01U + LFC1-UM02U +

LFC1-UM03U + LFC1-UM04U +

LFC1-UM05U + LFC1-UM06U +

LFC1-UM07U + LFC1-UM08U +

LFC1-UM09U + LFC1-UM10U +

LFC1-UM11U + LFC1-UM12U.

FATTURATO = FATTURATO * '-1' .

7 REPLIES 7
Read only

Former Member
0 Likes
870

Multiply FATTURATO by -1.

Read only

Former Member
0 Likes
870
CLEAR FATTURATO.
FATTURATO = LFC1-UM01U + LFC1-UM02U +
LFC1-UM03U + LFC1-UM04U +
LFC1-UM05U + LFC1-UM06U +
LFC1-UM07U + LFC1-UM08U +
LFC1-UM09U + LFC1-UM10U +
LFC1-UM11U + LFC1-UM12U.
FATTURATO * -1.
Read only

Former Member
Read only

Former Member
0 Likes
870

hi,

after writng your code,since the value is negative,multiply that value by (-1) so that you will get a positive value.

Thanks,

Sneha

Read only

0 Likes
870

how to do it in the code?

Read only

0 Likes
870

Do as ..

FATTURATO = FATTURATO * -1.

Read only

Former Member
0 Likes
871

FATTURATO = LFC1-UM01U + LFC1-UM02U +

LFC1-UM03U + LFC1-UM04U +

LFC1-UM05U + LFC1-UM06U +

LFC1-UM07U + LFC1-UM08U +

LFC1-UM09U + LFC1-UM10U +

LFC1-UM11U + LFC1-UM12U.

FATTURATO = FATTURATO * '-1' .