Variable based on If condition

[guillaume_gorli]

Hi everyone,

I am trying to build an app regarding customer satisfaction for which i will need some help.

The idea is to determine wether a customer is satisfied because delivered on time. The trick is that i have on my database, key part numbers that have to be delivered very quickly and others that have to be delivered the normal way.

I have then a test database with basic informations :

• Part number
• Codification that determined wether part number has to be delivered urgently or not
• Order number
• Order creation date
• Customer requested date
• Invoicing date

First issue is that i have to determine a leadtime based on the codification :

If part number is linked to codification A, then the customer leadtime is invoicing date versus order creation date

If part number is linked to codification B, then the customer leadtime is invoicing date versus customer requested date

Basically the output of such criteria should be :

Second step is is to determine directly from the app wether the customer is satisfied or not. The rule to apply is that the customer is satisfied  if the leadtime is less than or equal to zero.

Basically the output of such criteria should be :

My guess is that i have to set up variables based on a condition like IF formula in excel but i am stuck

Attached is test database as well as .qvw app for those who want to help.

Thanks in advance

[sunny_talwar]

No problem. Pleasure is all mine

Best,

Sunny