5 Replies Latest reply: Nov 21, 2012 1:33 AM by evrm RSS

    how to change currency format

    Tauceef
      Hello Everyone,

      In our application we need the currency in 10'000'000 format, I got how to get this format here

      Currency Formatting

      but now I need to show this in my form.

      I have a Automated row fetch process and I want to display the currency fields in the above format, but in Format mask that format is not available.

      how can I do that, client don't want to create a manual Sql process.

      Please let me know how to do this.

      Regards,
      Tauceef
        • 1. Re: how to change currency format
          evrm
          Hi Tauceef,

          you could change your SQL statement to select the value with the following to_char statement:
          SELECT TO_CHAR (10000000000000, '999G999G999G999G990', 'NLS_NUMERIC_CHARACTERS = ''.''''') FROM DUAL;
          That way you don't need an extra format mask.

          regards,
          Erik-jan
          • 2. Re: how to change currency format
            Tauceef
            hello evrm,

            As I said I have a Automated Fetch Row process, didn't have any Sql process, that's the problem, and client don't want a Sql process to be written.

            I tried doing that using a onload "After Header" Computation, but that's also not working.

            Regards,
            Tauceef
            • 3. Re: how to change currency format
              evrm
              Hi Tauceef,

              put the to_char statement in the"Post Calculation Computation" for the item.
              That should do the trick.

              regards,
              Erik-jan
              • 4. Re: how to change currency format
                Tauceef
                Hi evrm,

                Format is coming up now, but one more problem, when I submit the page, I am getting error "Character to number conversion error"

                I tried to create a computation on submit using this code, but its also not working

                replace(:P201_NONBANKABLE_ASSET_ACTUAL,'''',',')

                Regards,
                Tauceef
                • 5. Re: how to change currency format
                  evrm
                  Hi Tauceef,

                  make sure the item P201_NONBANKABLE_ASSET_ACTUAL is defined as Text Field.
                  The error message show that Apex is trying to make a number out of 10'000'000.
                  This way the computation should work now.

                  regards,
                  Erik-jan