Negative to positive values

[krishna20]

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

[sushil353]

Hi,

Try :

Aggr(Concat(expression,','),dimension)

HTH

Sushil

[krishna20]

Hi Sushil,

It's Not working for me.

Regards

Krishna

[jagan]

Hi,

Try this expression

=Concat(Aggr(DimensionName, DimensionName), ',', DimensionName)

Regards,

Jagan.

[krishna20 · Accepted solution]

Hi ,

Thank you for your suggestions.

It's working by following this link. and small modification.#.##0;(#.##0). Here i replaced comma.#,##0;(#,##0)

*** Negative Value to Positive Value ***

Regards

Krishna