Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In one of my requirements, I need to display negative numbers in brackets for specific rows. I am using 'IF ' for this in expressions and the num () function - with format '#.#%;(#.#%), but it is giving me discrepnacies in result as in -
for Num (-1.4,'#.#%;(#.#%)') result is (1.4%) but for Num (1.4,'#.#%;(#.#%)') the result of 140%
Please help me on this.
Sonika
for Num (-1.4,'#.#%;(#.#%)') result is (1.4%) but for Num (1.4,'#.#%;(#.#%)') the result of 140%
Num (1.4,'#.#;(#.#)') &'%'
Hi,
You should use like this
=Num (1.4/100,'#.#%;(#.#)%')
or
=Num (1.4/100,'#.#;(#.#)')&'%'
Hi,
In the Properties Tab of the chart,
Goto Number Tab,sleect the expression
goto Fixed to and paste the below format in the format pattern.
#.##0,00; (#.##0,00)
Regards,
Snehal Nabar