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
1,200

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
1,150

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
1,150

Multiply FATTURATO by -1.

Read only

Former Member
0 Likes
1,150
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
0 Likes
1,150

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
1,150

how to do it in the code?

Read only

0 Likes
1,150

Do as ..

FATTURATO = FATTURATO * -1.

Read only

Former Member
0 Likes
1,151

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' .