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

[mohit_tyagi]

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

[mohit_tyagi · Accepted solution]

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 !

[mohit_tyagi]

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]

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