Need help with some complicated logic

G

Guest

Hello all!

I am having some issues with the logic on the below SQL formula, and
wanted to see if one of you guru's could help me out ;).

First off, I do know that reverse logic would work a little better here,
but for my own learning, I would like to see how this would work with normal
logic.

The main issue I am having, is the piece where [Engagement Delivery Type]
= "To Partner - MS Prime" needs to be linked to [Subcontract hours]>0. So the
other criteria [Engagement Delivery Type] = "Through Partner - Partner
Prime", doesnt necessarily have to have [subcontract hours] >0. Maybe I am
too tired but my logic is not turning on and I can't think of a solution =)

IIF([CSAT Survey?] = "YES"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [subcontract hours] > 0
AND [Global Partner] <> "No Partner"
OR [CSAT Survey?] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner"
OR [CSAT Survey?] = "NO"
AND [Reason for No Survey] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner"
OR [CSAT Survey?] = "NO"
AND [Reason for No Survey] is null
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner" ,"TRUE","FALSE") As [Test Check]
 
G

Guest

I think you just need some paranthesis in this to make it work properly. Try:

IIF(([CSAT Survey?] = "YES"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [subcontract hours] > 0
AND [Global Partner] <> "No Partner")
OR ([CSAT Survey?] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner")
OR ([CSAT Survey?] = "NO"
AND [Reason for No Survey] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner")
OR ([CSAT Survey?] = "NO"
AND [Reason for No Survey] is null
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner") ,"TRUE","FALSE") As [Test Check]

HTH
Dale


--
Email address is not valid.
Please reply to newsgroup only.


havocdragon said:
Hello all!

I am having some issues with the logic on the below SQL formula, and
wanted to see if one of you guru's could help me out ;).

First off, I do know that reverse logic would work a little better here,
but for my own learning, I would like to see how this would work with normal
logic.

The main issue I am having, is the piece where [Engagement Delivery Type]
= "To Partner - MS Prime" needs to be linked to [Subcontract hours]>0. So the
other criteria [Engagement Delivery Type] = "Through Partner - Partner
Prime", doesnt necessarily have to have [subcontract hours] >0. Maybe I am
too tired but my logic is not turning on and I can't think of a solution =)

IIF([CSAT Survey?] = "YES"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [subcontract hours] > 0
AND [Global Partner] <> "No Partner"
OR [CSAT Survey?] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner"
OR [CSAT Survey?] = "NO"
AND [Reason for No Survey] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner"
OR [CSAT Survey?] = "NO"
AND [Reason for No Survey] is null
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner" ,"TRUE","FALSE") As [Test Check]
Click to expand...
 
G

Guest

Thanks I think that helped to, here is my solution (tested and works)

IIF(([CSAT Survey?] = "YES"
AND [Engagement Name] Not Like "SR-*"
AND [Global Partner] <> "No Partner"
AND [Engagement Delivery Type] = "Through Partner – Partner Prime")
OR([CSAT Survey?] = "YES"
AND [Engagement Name] Not Like "SR-*"
AND [Global Partner] <> "No Partner"
AND [Engagement Delivery Type] = "To Partner – MS Prime" )
OR([CSAT Survey?] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Global Partner] <> "No Partner"
AND [Engagement Delivery Type] = "Through Partner – Partner Prime")
OR([CSAT Survey?] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Global Partner] <> "No Partner"
AND [Engagement Delivery Type] = "To Partner – MS Prime")
OR([CSAT Survey?] = "NO"
AND [Reason for No Survey] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Global Partner] <> "No Partner"
AND [Engagement Delivery Type] = "Through Partner – Partner Prime")
OR([CSAT Survey?] = "NO"
AND [Reason for No Survey] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Global Partner] <> "No Partner"
AND [Engagement Delivery Type] = "To Partner – MS Prime")
OR([CSAT Survey?] = "NO"
AND [Reason for No Survey] is null
AND [Engagement Name] Not Like "SR-*"
AND [Global Partner] <> "No Partner"
AND [Engagement Delivery Type] = "Through Partner – Partner Prime")
OR([CSAT Survey?] = "NO"
AND [Reason for No Survey] is null
AND [Engagement Name] Not Like "SR-*"
AND [Global Partner] <> "No Partner"
AND [Engagement Delivery Type] = "To Partner – MS Prime"),"TRUE","FALSE") AS
[Test Check]

Dale Fye said:
I think you just need some paranthesis in this to make it work properly. Try:

IIF(([CSAT Survey?] = "YES"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [subcontract hours] > 0
AND [Global Partner] <> "No Partner")
OR ([CSAT Survey?] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner")
OR ([CSAT Survey?] = "NO"
AND [Reason for No Survey] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner")
OR ([CSAT Survey?] = "NO"
AND [Reason for No Survey] is null
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner") ,"TRUE","FALSE") As [Test Check]

HTH
Dale


--
Email address is not valid.
Please reply to newsgroup only.


havocdragon said:
Hello all!

I am having some issues with the logic on the below SQL formula, and
wanted to see if one of you guru's could help me out ;).

First off, I do know that reverse logic would work a little better here,
but for my own learning, I would like to see how this would work with normal
logic.

The main issue I am having, is the piece where [Engagement Delivery Type]
= "To Partner - MS Prime" needs to be linked to [Subcontract hours]>0. So the
other criteria [Engagement Delivery Type] = "Through Partner - Partner
Prime", doesnt necessarily have to have [subcontract hours] >0. Maybe I am
too tired but my logic is not turning on and I can't think of a solution =)

IIF([CSAT Survey?] = "YES"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [subcontract hours] > 0
AND [Global Partner] <> "No Partner"
OR [CSAT Survey?] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner"
OR [CSAT Survey?] = "NO"
AND [Reason for No Survey] = "N/A"
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner"
OR [CSAT Survey?] = "NO"
AND [Reason for No Survey] is null
AND [Engagement Name] Not Like "SR-*"
AND [Engagement Delivery Type] = "Through Partner - Partner Prime"
AND [Engagement Delivery Type] = "To Partner - MS Prime"
AND [Subcontact hours] >0
AND [Global Partner] <> "No Partner" ,"TRUE","FALSE") As [Test Check]
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Amazon are rubbish 14
Complicated Calculated Field Logic 0
AD Replication Monitor Status Report 5
Email from the FBI! 3
Query With Ranges in output? 2
The Razer Phone 6
AD REPLICATION FAILURE. HELP!!! 3
MAINFRAME Training with IBM Certification and JOB GUARANTEE: 0

Top