Need to return numbers to 2 decimal places

[dmxmikey]

i have the below script but not returnung value to 2 dp

please help

(NUM(Round(SUM(If([o-wsv]<>0,[o-wsv] ,
([o-cost] * if([o-split]=0,[o-sentqty],[o-sentqty]/[p-pack])) -
([o-cost] * [o-sentqty] * [o-discpc] /100))),0.01))*-1) as Value

[mohitp]

Hi,

Please try the below code:

(NUM(Round(SUM(If([o-wsv]<>0,[o-wsv] ,
([o-cost] * if([o-split]=0,[o-sentqty],[o-sentqty]/[p-pack])) -
([o-cost] * [o-sentqty] * [o-discpc] /100))),0.01), '#,###.00','.',',')*-1) as Value

[dmxmikey]

Thanks for the code, have tried and still returns 1 dp