Hi All,

In report layout,
how to display negative amount in bracket..
e.g : -1000 > (1000)

Thank You.

Use sprintf$() (http://www.baanboard.com/programmers_manual_baanerp_help_functions_formatting_io_sprintf) with edit$() formatting characters.

Example:
sprintf$("%@(ZZZZVD99)@", -1.23))

In the Print expression just do

"(" & amount & ")"

It will come in brackets.

Hi Manish,

Thanks for your solutions...it's working.

And also thanks to Ajesh.

Thank You.

In the Print expression just do

"(" & amount & ")"

It will come in brackets.

I think req. is to show only negative value in bracket and not positive one.