Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I am using the below expression to format the numbers to one decimal place but i am not getting the result.
I have a report which is added as Level in nPrinting.
=NUM(IF(Desc=value,Column,''),'#.0;(#.0)')
Regards,
Viresh
I got the solution. I need to use the num function within the if function.
Like if(Desc=value,num(Column,'#.0;(#.0)')
Can you please try
#,##0.0
Thanks
Agnivesh
Not working. If i use the modified version of the above expression (If(Desc=value, Column, '')), i get the numbers exactly but i need to show the negative numbers in brackets. I need some way to show the negative numbers in brackets like -8 as (8).
Assuming this is an Excel report
This should give you the desired result.
Best
Aran
I got the solution. I need to use the num function within the if function.
Like if(Desc=value,num(Column,'#.0;(#.0)')