Positive to Negative values

krishna20 — Mon, 29 Dec 2014 09:44:27 GMT

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

Re: Positive to Negative values

jagan — Tue, 30 Dec 2014 06:28:13 GMT

Hi,

Try this expression

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

Regards,

Jagan.