Hi Friends,
I need to show the values from negative to positive with comma separated.
i used two ways to achieve this.
1. =if(YourExpression<0,chr(91)&fabs(YourExpression)&chr(93),YourExpression)
Result : Getting in square brackets.But, the value of one expression is not adding to another one.The another expression is showing as null.
E.g;
Paid:
=if(A<0,chr(91)&fabs(A)&chr(93),A)
O/P [23456]
premium:
=if(Paid+insured<0,chr(91)&fabs(Paid+insured)&chr(93),Paid+insured)
O/P : -
2.Number Tab-> Integer ->#.##0;(#.##0)
It's adding values to another expression.I need comma separated values.
Please any help can be appreciated.
Regards
Krishna
