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.
Discussion posts and replies are publicly visible
Hello ponmurugana2702 , 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
Thank You for your Response.
ponmurugana2702 said:I tried several logics
Explaining what you tried before would help us to find a good answer for you.
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)
It worked Chaitanya. Thank you for cleared my doubt.
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.