Code
-------------------------
a!localVariables( local!currencyValue: a!currency( isoCode:"USD", value:-152552.774, format:"SYMBOL", decimalPlaces:2, indicatorAlignment: "START" ), stripwith( local!currencyValue, "$" ) )
Output
--------------------------
"(152,552.77)"
I need the output as "152,552.77".Can some one help to rectify the code
Discussion posts and replies are publicly visible
akhileshr0549 said:I need the output as "152,552.77"
Why are you using a!currency() if you don't actually want the output in currency?
If you just need the output formatted with commas and a fixed decimal, just use "fixed()".
As I mentioned before, you can get the absolute value of the input number using "abs()".
fixed( abs(-152552.774), 2, false() )
As I always say - the Functions Doc Page is your friend!! Keep it open in a browser tab!