Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi,
Try this link, It may helps
Need to convert Negative values to positive values with[ ] and red font
Regards
Krishna
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
You should close the discussion, if reached the goal, by choosing one correct or helpful answer for others to learn.
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