Font color and style for Expression Column value

[#1]

Hi,

I have sum(Amounts) column as a Expression. My requirement is,

if sum(Amounts) has negative value , that negative value should be Red Color and that negative value in brackets like ( ).

How can i achieve this, could you please tell me Set expression and process

Thanks,

MLNR

[krishna20]

hi,

Try this link, It may helps

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

Regards

Krishna

[krishna20]

Hi,

Goto properties -> Number Tab-> Select your Expression-> Select Integer -> In Format Pattern replace this #,##0;(#,##0)

Then

Goto Expression Tab-> Select your Expression -> Expand it by + mark. Select Text Format.Then write like this

if(sum(Sales)>=0,bllack(),Red())

Hope this helps

Regards

Krishna

[senpradip007]

You should close the discussion, if reached the goal, by choosing one correct or helpful answer for others to learn.

[gautik92]

You can also set flag for it by using this formula

If(Sum(Sales) <= 0,'qmem://<bundled>/BuiltIn/arrow_s_r.png','qmem://<bundled>/BuiltIn/arrow_n_g.png')

And select the expression and choose image and select keep aspect