Hi All, I want to display a amount on screen which will be a sum of multipl

himanshun over 9 years ago

Hi All,
I want to display a amount on screen which will be a sum of multiple values, however if this value is negative, it is displayed in curly brackets e.g.: ($5,000.00). Is there any function/rule in Appian which can display the amount without the brackets and with a negative sign? e.g.: -$5,000.00

Thank you in advance

Discussion posts and replies are publicly visible

0 ashokv
A Score Level 1
over 9 years ago

U can try using the text function and check for eg: text(value,"$0000"). Here even if the value is -ve u can get -ve values displayed.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 janakik over 9 years ago

Simply you can use dollar(abs(variable)).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chrism967 over 9 years ago

You don't want the abs() as that will make the value always positive.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 janakik over 9 years ago

Sorry I was mistaken, using sign function you can show proper currency format.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nareshs427
Certified Senior Developer
over 9 years ago

Hi Himanshu,
Please try the below expression..
stripwith(if(sign(ri!amount)=-1,append("-",dollar(ri!amount)),dollar(ri!amount)),"()")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 himanshun over 9 years ago

Thank you for your responses, however i still have the brackets "()" along with the amount. I am already using append function here.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 nareshs427
Certified Senior Developer
over 9 years ago

Expression results with out brackets. Can you please double check?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 himanshun over 9 years ago

Thanks Naresh... able to get rid of the brackets now
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel