Elrodyn
4th October 2011, 11:21
Dear Fellowship of the baan/LN,


i need some help again on the amount formatting on the LN, is it possible to create a format that make the minus amount has parenthesis on it?

for example the -500 amount is shown as (500) on the system.

i've tried some formats that come in mind..but no luck so far.


Thanks,

Roy

dhruv_x0
12th October 2011, 13:44
Dear Elrodyn,

I don't know any standard format or function which can fulfill ur requirement but u can do it in script itself. Check if amount is negative then find its absolute value using abs(amnount). And Then can add parenthesis to that amount.


Hope wl help.

Elrodyn
14th October 2011, 03:50
Hello dhruv_X0,


let me try your solution, thanks,

Roy