Need to convert Negative values to positive values with[ ] and red font

[krishna20]

Hi Friends,

How to show negative values to positive values within [  ] and red color font.Please anyone can suggest me how to achieve it.

Regards

Krishna

[ashfaq_haseeb]

Hi,

Try something like this

=if(YourExpression<0,chr(91)&fabs(YourExpression)&chr(93),YourExpression)

Regards

ASHFAQ

[ashfaq_haseeb]

Hi,

Try something like this

if(YourExpression<0,chr(91)&fabs(YourExpression)&chr(93),YourExpression)

Regards

ASHFAQ

[jpenuliar]

you can start with fabs() function

[#5]

fabs(-20)  =   20

[PrashantSangle]

Hi,

Use num()

try like

num(value,'#,##0.00;[#,##0.00]')

and

For red font click on + symbol -> go to text color->write if(value<0,RED())

Regards,

[ashfaq_haseeb · Accepted solution]

HI,

Check this

I add reply but its under moderation don't know why.

Check the attached File and let me know if that worked.

Regards

ASHFAQ

[Anonymous]

Hi

try like this

Test:

LOAD * INLINE [

    City, Amount

    Berlin, -100

    Zurich, 200

];

create a straight table in expression write  fabs(sum(Amount))

and in background color write if(sum(Amount)<0,red())

hope this will help you

thanks