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,192

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,142

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,142

Multiply FATTURATO by -1.

Read only

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

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,142

how to do it in the code?

Read only

0 Likes
1,142

Do as ..

FATTURATO = FATTURATO * -1.

Read only

Former Member
0 Likes
1,143

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