Nesting If statements 1

[ComputerNurse]

What is the best way to create a formula that can execute multiple lines? I would like to also like pad the end of the Insurance_no with spaces if they are less than 7.


IF {1005680VW_SERVICE_SUPPLY.VISIT_INS_CODE}= 'PA' THEN
LEFT({1005680VW_SERVICE_SUPPLY.VISIT_INS_NO},7)
ELSE IF


({1005680VW_SERVICE_SUPPLY.PRIMARY_INS_CODE}) = 'PA'THEN
lEFT({1005680VW_SERVICE_SUPPLY.INSURANCE_ID_NO},7)

 

[synapsevampire]

I'm not sure what you mean by execute multiple lines, what you posted is correct if you want to take the
{1005680VW_SERVICE_SUPPLY.VISIT_INS_NO}
for those that have
{1005680VW_SERVICE_SUPPLY.VISIT_INS_CODE}= 'PA'
and if not take the
{1005680VW_SERVICE_SUPPLY.INSURANCE_ID_NO}
for those that have
({1005680VW_SERVICE_SUPPLY.PRIMARY_INS_CODE}) = 'PA'

This should supply the padding you seek:

IF {1005680VW_SERVICE_SUPPLY.VISIT_INS_CODE}= 'PA' THEN

if len(trim(LEFT({1005680VW_SERVICE_SUPPLY.VISIT_INS_NO},7))) < 7 then
{1005680VW_SERVICE_SUPPLY.VISIT_INS_NO} + replicatestring(&quot; &quot;,7-(len(trim({1005680VW_SERVICE_SUPPLY.VISIT_INS_NO}))))
else
left({1005680VW_SERVICE_SUPPLY.VISIT_INS_NO},7)

and continue on with your else ifs

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com