Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[Procurement Type]
[Primary Contract Type]
[Procurement Action]
From these fields I would like to create a new field called "COR Type" based on multiple criteria found within the fields above using an IF Statement:
if(([Procurement Type]='SERVICES' or 'R&D' or 'CONSTRUCTION') and ([Primary Contract Type]='Firm Fixed Price' or 'Order Dependent') and ([Procurement Action]<>'*MOD*'),'Type A',
if(([Procurement Type]='SERVICES' or 'R&D' or 'CONSTRUCTION') and ([Primary Contract Type]<>'Firm Fixed Price' or 'Order Dependent' or '*Cost*') and ([Procurement Action]<>'*MOD*'),'Type B',
if(([Procurement Type]='SERVICES' or 'A&E' or 'R&D' or 'CONSTRUCTION') and ([Primary Contract Type]='*Cost*') and ([Procurement Action]<>'*MOD*'),'Type C'))) AS "COR Type"
The new "COR Type" field is created but the results only show Type A and Type B when the [Procurement Type] = Services. All the other [Procurement Type] are not evaluated nor is the [Primary Contract Type] and [Procurement Action] evaluated. Thank you in advance for your assistance!
Hi
fine?
try:
if(
Wildmatch([Procurement Type],'SERVICES','R&D','CONSTRUCTION')>0 and
Wildmatch([Primary Contract Type],'Firm Fixed Price','Order Dependent')>0 and
Wildmatch([Procurement Action],'*MOD*')=0,
'Type A',
if(
Wildmatch([Procurement Type]='SERVICES','R&D','CONSTRUCTION')>0 and
Wildmatch([Primary Contract Type],'Firm Fixed Price','Order Dependent','*Cost*')=0 and
Wildmatch([Procurement Action],'*MOD*')=0,
'Type B',
if(
Wildmatch([Procurement Type],'SERVICES','A&E','R&D','CONSTRUCTION')>0 and
Wildmatch([Primary Contract Type],'*Cost*')>0 and
Wildmatch([Procurement Action],'*MOD*')=0,
'Type C'
)
)
) AS "COR Type"
Regards
Hi
fine?
try:
if(
Wildmatch([Procurement Type],'SERVICES','R&D','CONSTRUCTION')>0 and
Wildmatch([Primary Contract Type],'Firm Fixed Price','Order Dependent')>0 and
Wildmatch([Procurement Action],'*MOD*')=0,
'Type A',
if(
Wildmatch([Procurement Type]='SERVICES','R&D','CONSTRUCTION')>0 and
Wildmatch([Primary Contract Type],'Firm Fixed Price','Order Dependent','*Cost*')=0 and
Wildmatch([Procurement Action],'*MOD*')=0,
'Type B',
if(
Wildmatch([Procurement Type],'SERVICES','A&E','R&D','CONSTRUCTION')>0 and
Wildmatch([Primary Contract Type],'*Cost*')>0 and
Wildmatch([Procurement Action],'*MOD*')=0,
'Type C'
)
)
) AS "COR Type"
Regards
THANK YOU, it worked!