Search code examples
oracle11goracle10goracle-apexoracle-apex-5.1oracle-apex-5

Getting NaN as output in my display only item oracle


I am getting NaN as output in Display only field..

Below is my query which is in page (function and global variable)

In this i am getting NaN for the item when the value having comma like 1,500.0 :P2510_OUTSTANDING_AMOUNT


Solution

  • how to remove commas from unalloc_value in my Javascript

    The same way you already do with match-value -

        match_value = match_value.replace(/,/g, '');
        match_value = Number(match_value, 10);
        unalloc_value = Number(unalloc_value, 10); // BQ4-5024
    

    Just add another replace:

        match_value = match_value.replace(/,/g, '');
        match_value = Number(match_value, 10);
        unalloc_value = unalloc_value.replace(/,/g, '');
        unalloc_value = Number(unalloc_value, 10); // BQ4-5024