Skip to main content
P
ponmurugana2702
March 5, 2025
Solved

Currency

  • March 5, 2025
  • 6 replies
  • 0 views

Hi People, 

 I have input task USD 12345789. I want to put comma between the amount based on currency and I want output like USD 1,23,456.89. I tried several logics but not worked and output is USD1234,567.89. Can anyone help me? Thanks in advance. 

    Best answer by konduruc733182

    Hello [mention:8d5ee0b4020145db96483432ebd01eae:e9ed411860ed4f2ba0265705b8793d05] , Have you tried using the a!currency() function? isoCode parameter will define the format based on the input given.

    docs.appian.com/.../fnc_text_currency.html

    6 replies

    konduruc733182
    konduruc733182Answer
    March 5, 2025

    Hello [mention:8d5ee0b4020145db96483432ebd01eae:e9ed411860ed4f2ba0265705b8793d05] , Have you tried using the a!currency() function? isoCode parameter will define the format based on the input given.

    docs.appian.com/.../fnc_text_currency.html

      P
      ponmurugana2702Author
      March 5, 2025

      Thank You for your Response.

      stefanhelzle0001
      stefanhelzle0001
      March 5, 2025
      I tried several logics

      Explaining what you tried before would help us to find a good answer for you.

      P
      ponmurugana2702Author
      March 5, 2025

      Thank You Stefan. 

      a!localVariables(
      local!amount: 1234567.89,
      local!currency: "USD",

      local!formattedAmount: if(
      local!currency = "INR",

      left(text(floor(local!amount), "#,##,##0")) & "." & right(text(local!amount, "0.00"), 2),


      a!localVariables(
      local!intPart: floor(local!amount),
      local!decimalPart: right(text(local!amount, "0.00"), 2),


      local!intFormatted: text(local!intPart, "#,###"),


      local!intFormatted & "." & local!decimalPart
      )
      ),

      local!formattedAmount
      )

      B
      becketth375100
      March 11, 2025

      Handling currency formatting inconsistencies can be challenging. Have you ensured that localization settings align with regional currency formats? Implementing proper data validation and conversion logic might help standardize formatting across different user interfaces. What specific issues are you encountering with currency display? Many students worry about plagiarism and poor-quality essays when using online writing services. UKTopWriter evaluates different platforms to ensure that only the best essay writing services are recommended. If you're looking for reliable writing services, check out uktopwriter.com/.../ for expert recommendations. Their reviews highlight key features such as originality guarantees, experienced writers, and timely delivery.

      Terms & ConditionsAccessibility statement