cancel
Showing results for 
Search instead for 
Did you mean: 

Product of two transaction screen field need to display in 3rd field, not working correctly

mohit_tyagi
Participant
0 Kudos

Hi Experts,

I am working on transaction screen where two decimal type field (1st field type is complex table which is returning decimal value and 2nd field type is data table which returning number) and trying to display value in 3rd field. But value is not coming correctly.

if CT table returning .25 and DT table returning 1 then its showing output 0.

desimal-issue-with-ct.png

Please help to resolve.

Regards

Mohit

Accepted Solutions (1)

Accepted Solutions (1)

mohit_tyagi
Participant
0 Kudos

Thanks all.

I got solution for this. Earlier we are trying FROM_DECIMAL_NUMBER, but to get correct result We need to use PARSE_FORMATTED_DECIMAL function. it return decimal number.

Thanks

Mohit !

Answers (2)

Answers (2)

mohit_tyagi
Participant
0 Kudos

Hi Oliver,

Thanks for the reply, I tried above but getting same result.

Might be issue happen because one value is coming from Complex table( decimal number) and another value coming from data table (integer number). while i am using prod, even i am displaying in another field with update rule its not displaying decimal number. Only displaying 0,1 etc. All field type is decimal.

Thanks

Mohit.

oliver_kaluscha3
Participant
0 Kudos

Hi Mohit,

just by looking at it I would say it converts both tu number - so it calculates 0 * 1 = 0. Just convert 1 to 1.0 and make sure it calculates decimals. So it should be okay.

Oliver