Expression consolidation

[Anonymous]

Can the following two expressions be combined into one expression:

Thanking you in advance

Regards.

[Anonymous · Accepted solution]

like this?

=if(len(trim([Doctor Number]))=0, '00000',

  if(len(trim([Doctor Number])) >=6 and [Retail Pharmacy]='PSMAS', '00001', [Doctor Number])) as [Doctor Number]

[jagan]

HI,

Try like this

=If(Len(Trim([Doctor Number]))=0, '00000',

  If(Len(Trim([Doctor Number])) >=6 AND[Retail Pharmacy]='PSMAS', '00001', [Doctor Number])) AS [Doctor Number]

[Anonymous]

Many thanks Bairaj, i will try it out and advise outcome

Regards

[Anonymous]

Thanks Jagan, i am trying this out and will let you know outcome

Regards.

[amit_saini]

Hi Chris,

This should work:

Thanks,

AS

[Anonymous]

Amit may thanks i am trying this out

[avinashelite]

if you have got the correct answer please mark the correct answer and close this thread

[Anonymous]

Hi Balraj

Many thanks that works.  i have problems with using the if(Len(Trim function on its own and want to incorporate it with the NULL function as follows:

     if(len(trim([Doctor Number]) = 0 or If(IsNull([Doctor Number])), '00000',  if(len(trim([Doctor Number])) >= 7 and [Retail Pharmacy]='PSMAS', '00001', [Doctor Number])) as [Doctor Number]

There is something wrong with the above expression and i am failing to figure out the error.  Kindly assist

[amit_saini]

Try:

if(IsNull([Doctor Number]),'00000',if(len(trim([Doctor Number])) >= 7 and [Retail Pharmacy]='PSMAS', '00001', [Doctor Number])) as [Doctor Number]

Thanks,

AS