Negative to positive number conversion

[Anonymous]

I have the following expression

Num([Drug Code],'000000') as [Drug Code]

How can the above expression be adapted to change negative numbers into positive numbers in cases where these negative numbers exist in addition to formatting a number into a six digit one when required?

Regards

Chris

[preminqlik · Accepted solution]

try this

Num(fabs([Drug Code]),'000000')  as [Drug Code]

[jagan]

Hi,

Use Fabs() to convert negative to positive.

Fabs(Num([Drug Code],'000000')) as [Drug Code]

Regards,

Jagan.

[Anonymous]

Prem, many thanks, i will try it out and revert

Regards

Chris

[Anonymous]

Jagan, many thanks, i will try it out and advise accordingly

Regards.

Chris