Expression consolidation

[Anonymous]

Can the following two expressions be combined into one expression:

Thanking you in advance

Regards.

[Anonymous]

Try this?

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

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

[Anonymous]

With Isnull() , you dont required to write If() again...

It should be like this

if(len(trim([Doctor Number])) = 0 or IsNull([Doctor Number]),