Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Thanks for the code, have tried and still returns 1 dp